Consider a relation with attributes [A, B, C, D] and the following functional…

RPSC Programmer · 2024 · Paper I

Consider a relation with attributes [A, B, C, D] and the following functional dependencies: A → B, B → C and C → D. If A is the primary key, which of the following is true regarding BCNF?

  1. A.

    The relation is in BCNF because all determinants are super keys.

  2. B.

    The relation is in 3NF but not in BCNF.

  3. C.

    The relation is not in BCNF.

  4. D.

    The relation is in BCNF because it is in 3NF.

  5. E.

    Question not attempted

Attempted by 628 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…