Identifying Related Entities and Attributes for a Repository

After all the entities are identified, you need to identify all related entities and attributes.

Procedure

Normalize the resulting model.
Associate the subentities with entities through relationships or foreign key lookups.
Separate the entities from the list that store data coming from external sources. For example, if you are getting addresses from external systems to store in TIBCO MDM, the address may be mapped to the repository ADDRESS and the data acquired from the external system is a data source DS_ADDRESS.
Denormalize the tables with access patterns in mind. For example, you can have a Customer entity where a customer has a phone number stored in Phone entity. However, if one of the phone numbers is the main phone that is always accessed along with the customer and is logically considered part of the customer details, you may want to store this phone number as an attribute in the Customer entity itself.
Group attributes logically and assign positions to the attributes within group so that they are sequenced in a logical order.