ISRO | ISRO CS 2007 | Question 54
BCNF is not used for cases where a relation has
(A) Two (or more) candidate keys
(B) Two candidate keys and composite
(C) The candidate key overlap
(D) Two mutually exclusive foreign keys
Explanation: A relation is in BCNF if all attributes which are determinants are also candidate keys in every relation.
Transformation into BCNF deals with the problem of overlapping keys and there is no problem with two or more CK.
Option (D) is correct.
Quiz of this Question