10.4. Boyce-Codd Normal Form (BCNF)

To eliminate the problems and redundancy of 3NF, R.F. Boyce proposed a normal form known as Boyce-Codd normal form (BCNF). Relation R is said to be in BCNF if for every nontrivial FD: XY between attributes X and Y holds in R. That means:

  • X is super key of R.

  • XY is a trivial FD, that is, YX.

In other words, a relation must only have candidate keys as determinants. Thus, to find whether a relation is in BCNF or not, FDs within each relation is examined. If all non-key attributes depend upon only the complete key, the relation is in BCNF.

Any relation in BCNF is also in 3NF and consequently in 2NF. However, a relation in 3NF is not necessarily in BCNF. The BCNF is a simpler form of 3NF and eliminates ...

Get Database Systems: Concepts, Design and Applications now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.