## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

### 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 ...

## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

No credit card required