Which of the following is false?

2014

Which of the following is false?

  1. A.

    Every binary relation is never be in BCNF.

  2. B.

    Every BCNF relation is in 3NF.

  3. C.

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

  4. D.

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

Attempted by 273 students.

Show answer & explanation

Correct answer: A

The question asks for the false statement regarding database normalization. Option 0 asserts that binary relations are never in BCNF, which is false because all binary relations (relations with two attributes) are inherently in Boyce-Codd Normal Form. Therefore, Option 0 is the correct selection as it represents an incorrect claim.

A video solution is available for this question — log in and enroll to watch it.

Explore the full course: Mppsc Assistant Professor