First page Back Continue Last page Overview Graphics
Normalization
Why Be Normal?
- Easy applications from well-designed data,
poorly designed data makes for tough apps
Primary Key (PK) uniquely defines record (1st)
All parts of PK required to identify record (2nd)
No other fields needed for uniqueness (3rd )
When a record wants to refer to another, it stores the PK of that record. That field is a foreign key (FK)