Conceptual Vs Logical Vs Physical Data Model

Conceptual Vs Logical Vs Physical Data Model

We had earlier seen the different types of data models

Conceptual Data Model

Logical Data Model

Physical Data Model

We shall now see the comparison between these models.

Conceptual Data Model	Logical Data Model	Physical Data Model
Very high level data model	High level data model	Low level data model
Only Entities (Tables) are defined	Entities & Attributes (Tables & Columns) are defined	Entities,  Attributes & Properties (Tables, Columns, Data Types & Size are defined)
Developed during the initial requirements phase of the project.	Developed during the late requirement / early design phases of the project.	Developed during the final design phase of the project.
Remains constant across databases	Remains constant across databases	Varies based on the target database.
Used to give a high level picture to the Business users.	Used by the Database administrators to Normalize and optimize the database.	Used more by the developers to develop the application.

Related Posts

Conceptual Data Model

Logical Data Model

Physical Data Model

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.