Boyce-Codd Normal Form (BCNF)

• R is in BFNC if whenever X?A holds, then X is a superkey.

• Slightly stronger than 3NF.

• Example: R(A,B,C) with {A,B}?C, C?A

  • 3NF but not BCNF

Guideline: Aim for BCNF and settle for 3NF

Previous slide

Back to first slide

View graphic version