Visual FoxPro DevCon 2001
Normalization
uWhy Be Normal?
nEasy applications from well-designed data,
poorly designed data makes for tough apps
uPrimary Key (PK) uniquely defines record (1st)
uAll parts of PK required to identify record (2nd)
uNo other fields needed for uniqueness (3rd )
uWhen a record wants to refer to another, it stores the PK of that record. That field is a foreign key (FK)
Reference: Dev 208 – Jim Booth Relational Database Design