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

PYQ RPSC Programmer 2024

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 662 students.

Sign up free to check your answer

Sign up free

Explore the full course: Rpsc Programmer

Loading lesson…