UGC-NET | UGC NET CS 2014 Dec – III | Question 12

Which of the following is false?
(A) Every binary relation is never be in BCNF.
(B) Every BCNF relation is in 3NF.
(C) 1 NF, 2 NF, 3 NF and BCNF are based on functional dependencies.
(D) Multivalued Dependency (MVD) is a special case of Join Dependency (JD).

Answer: (A)
Explanation:

Every binary relation is never be in BCNF. This statement is incorrect because Every binary relation is always in BCNF.

Every BCNF relation is in 3NF. Correct.

1 NF, 2 NF, 3 NF and BCNF are based on functional dependencies. Correct.

Multivalued Dependency (MVD) is a special case of Join Dependency (JD).Correct.

So, option (A) is correct.
Quiz of this Question