Question 45Asked in UGC NET Computer Science, December 2014 (Paper II & III, Selected Questions)
Which of the following is false ?
AEvery binary relation is never be in BCNF
BEvery BCNF relation is in 3NF
C1 NF, 2 NF, 3 NF and BCNF are based on functional dependencies
DMultivalued dependency (MVD) is a special case of join dependency (JD)
Show answerHide answer
Correct answer: (A) Every binary relation is never be in BCNF
Explanation
Every binary relation (a relation with only 2 attributes) is always in BCNF: if both attributes form the key it is in BCNF, and if one attribute is the key the other is determined by it. So statement (a) is false.
From UGC NET Computer Science PYQ, December 2014 (Paper II & III, Selected Questions)