Logical Data Modeling vs Physical Data Modeling
Logical Data Model | Physical Data Model |
Represents business information and defines business rules | Represents the physical implementation of the model in a database. |
Entity | Table |
Attribute | Column |
Primary Key | Primary Key Constraint |
Alternate Key | Unique Constraint or Unique Index |
Inversion Key Entry | Non Unique Index |
Rule | Check Constraint, Default Value |
Relationship | Foreign Key |
Definition | Comment |
posted by Jeyakumar @ Friday, December 02, 2011,
Post a Comment
Note: only a member of this blog may post a comment.