Studied by 0 people
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
