Boyce-Codd Normal Form (BCNF)

• Boyce-Codd Normal Form requires:

  • The relation is (1NF)
  • for every FD X → A, we have either A ⊂ X or X is a superkey of r(R)

• The second criteria implies 3NF (All BCNF relations are also 3NF but not all 3NF relations are BCNF)