Normalization follows certain rules for efficiently organizing data in a database. A table is in Boyce-Codd Normal Form (BCNF) when:

Question

Accepted Answer

Every determinant is a candidate key

Answer

All attributes are functionally dependent on the whole primary key.

Answer

All attributes are non-transitively dependent on the primary key.

Answer

All intermediary keys are relationally dependent on each other.

Answer

There are no repeating groups of attributes, and all values are atomic.

Crowdly