Lukas' Notes

relational-algebra

Definition

Boyce-Codd Normal Form

A schema is in Boyce-Codd normal form if for every functional dependency with attribute , at least one of the following two conditions holds:

  1. , i.e. the functional dependency is trivial
  2. is super key of

The BCNF is a more restrict version of the 3NF.