Normal Form
No change anomalies in expressing data revision
Rule of Thumb
Facts about different entities should be recorded in separate tables
Each relation schema should consist of two separate sets of Attributes
- Primary key to record facts that identify an entity
- Record independent facts about the entity
Goals
- Intuitive and straightforward data revision that avoids anomalies
- Non-redundant representation of data