Which one of the following statements is FALSE?
2017
Which one 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 a 3NF relation
- D.
A prime attribute can be transitively dependent on a key in a BCNF relation
Attempted by 138 students.
Show answer & explanation
Correct answer: D
This question asks to identify the FALSE statement regarding database normalization forms. Option 0 is true because any relation with two attributes satisfies BCNF conditions automatically. Since the question requires selecting the FALSE statement, choosing Option 0 is incorrect. The actual false statement is Option D because BCNF strictly prohibits transitive dependencies where the intermediate determinant is not a superkey.
A video solution is available for this question — log in and enroll to watch it.