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