Design Requirements for Relational Database
Every column must be single valued.
Primary keys must contain data (not null).
Foreign keys must contain the same data as the primary key in another table.
All other attributes must identify a characteristic of the table identified by the primary key.