printable version

Test 2 Review A

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] [12] [13] [14]

Problem R2a.1.

In studying normal forms, we first defined BCNF: A relation is in BCNF if every nontrivial functional dependency for that relation has a superkey on its left-hand side. We later explored a closely related but more complex definition, which we termed third normal form (3NF). Third normal form is more general than BCNF: That is, all BCNF relations are in 3NF, but some 3NF relations are not in BCNF.

  1. Explain the deficiency of BCNF that led to the definition of 3NF.

  2. Describe how the definition of 3NF differs from the definition of BCNF.