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