Boyce-Codd Normal Form (BCNF) requires that for every functional dependency X to Y, X must be a:

A relation is in second normal form (2NF) if it is in 1NF and:

A relation is in third normal form (3NF) if it is in 2NF and:

A partial dependency exists when a non-key attribute depends on:

A transitive dependency exists when a non-key attribute depends on:

The process of organizing relations to reduce data redundancy and improve integrity is called:

A relation is in first normal form (1NF) if: