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