Which of the following statements is false?
2014
Which of the following statements is false?
- A.
Any relation with two attributes is in BCNF.
- B.
A relation in which every key has only one attribute is in 2NF.
- C.
A prime attribute can be transitively dependent on a key in 3NF relation.
- 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.