Which of the following statements is false?
Show answerHide answer
Correct answer: (D) A prime attribute can be transitively dependent on a key in BCNF relation.
Explanation
A relation is in BCNF, if and only if, every determinant is a candidate key i.e. the left hand side of every non trivial dependency is a super key or there is a trivial dependency or both. After 3NF, there may arise a situation that two candidate keys are having one attribute in common (overlapping) and this overlapping must be cleared to satisfy BCNF. A prime attribute (an attribute that is a part of a candidate key) can on depend on a super key. So a prime attribute cannot be transitively dependent on a key in BCNF relation. So the false statement is option (d).