Tuesday, May 8, 2012

Conceptual Vs Logical Vs Physical Data Model


Conceptual Vs Logical Vs Physical Data Model
We had earlier seen the different types of data models

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


Search Flipkart Products:
Flipkart.com

No comments: