Match the normal form to its rule

Exercise and reference answers

Matching pairs

1. Left

   1NF

   Right

   Atomic values, no repeating groups

2. Left

   2NF

   Right

   1NF + no partial dependency on a composite key

3. Left

   3NF

   Right

   2NF + no transitive dependency

4. Left

   BCNF

   Right

   Every determinant is a candidate key