Which of the following statements is false?

2014

Which of the following statements is false?

  1. A.

    Any relation with two attributes is in BCNF.

  2. B.

    A relation in which every key has only one attribute is in 2NF.

  3. C.

    A prime attribute can be transitively dependent on a key in 3NF relation.

  4. D.

    A prime attribute can be transitively dependent on a key in BCNF relation.

Attempted by 251 students.

Show answer & explanation

Correct answer: D

To identify the false statement, we must compare the definitions of 3NF and BCNF. In Third Normal Form (3NF), a relation is valid if for every non-trivial functional dependency X -> Y, either X is a superkey or Y is a prime attribute. This allows prime attributes to be transitively dependent on the key. In contrast, Boyce-Codd Normal Form (BCNF) is stricter: it requires all determinants to be superkeys, which effectively prevents transitive dependencies involving non-prime attributes. Based on standard database normalization theory and the GATE CS 2006 key, Option 3 is identified as the false statement because it contradicts these strict definitions regarding determinants and superkeys in BCNF.

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

Explore the full course: Mppsc Assistant Professor