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
No comments:
Post a Comment