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 candidate key is a determinant
E)every determinant is a candidate key

Question

Quizplus · Accepted Answer

A relation is in BCNF if every determinant is a candidate key, ensuring no partial or transitive dependencies.

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