Logical Data Model

Logical Data Model

The Logical data model, is a high level data model which provides details of the entities (Tables) in the model, the relationship between the entities, the attributes/properties (Columns/Fields) specific to each of the entities. At this stage the details of the Primary/Foreign key are also know hence Normalization of the tables can be done at this stage.

This model can be used during the late requirement gathering / early design stages, at this stage we gain additional details on the attributes specific to each of the entities, hence we can get a concrete structure of each of the entities.