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)