Data Analysis for Database Design
What is a Good Data Model?
- A good data model is simple.
- As a general rule, the data attributes that describe an entity should describe only that entity.
- A good data model is essentially non-redundant.
- This means that each data attribute, other than foreign keys, describes at most one entity.
- A good data model should be flexible and adaptable to future needs.
- We should make the data models as application-independent as possible to encourage database structures that can be extended or modified without impact to current programs.