data normalisation

1NF (3)

• contain atomic values

• have no repeating groups

• have a unique identifier (primary key)

2NF (4)

• meet 1NF requirements

• only apply to tables with a compound primary key

• have full functional dependency (non-prime attributes being fully dependent on the primary key)

• have no partial dependencies (non-prime attributes cannot depend on only part of a primary key, separate tables should be created if they do)

3NF (2)

• meet all 2NF requirements

• have no transitive dependencies (non-prime attributes cannot depend on other non-prime attributes, only the primary key) - create a separate table and use a foreign key

holder

holder