A relation is in Boyce-Codd normal form (BCNF)if and only if it is in 3NF and ________.
A)all non-key attributes are determined by the entire primary key
B)there are no non-key attributes determined by another non-key attribute
C)every attribute is a candidate key
D)every determinant is a candidate key

Question

Quizplus · Accepted Answer

Boyce-Codd Normal Form (BCNF) is a stricter version of the Third Normal Form (3NF). A relation is in BCNF if and only if, for every one of its non-trivial functional dependencies X → Y, X is a superkey. This means every determinant in the relation, which is a set of attributes on the left side of the functional dependency, must be a candidate key.

A Relation Is in Boyce-Codd Normal Form (BCNF)if and Only