Boyce-Codd Normal Form

• Most 3NF relations are also BCNF relations.

• A 3NF relation is NOT in BCNF if:

  • Candidate keys in the relation are composite keys (they are not single attributes)
  • There is more than one candidate key in the relation, and
  • The keys are not disjoint, that is, some attributes in the keys are common

Previous slide

Next slide

Back to first slide

View graphic version