Logical Data Modeling

To review the methodology for completing a logical data model:

1. Identify and model the entities.
2. Identify and model the relationships between the entities.
3. Identify and model the attributes.
4. Identify unique identifiers for each entity.
5. Normalize the data model.

In practice, the process is rarely so linear. It is often tempting and appropriate to jump around between entities, relationships, attributes and unique identifiers. It is not as important to follow a strict process as it is to discover and capture all of the information necessary to correctly model the system.