-
Which one of the following statements is false?
-
- Any relation with two attributes is in BCNF
- A relation in which every key has only one attribute is in 2NF
- A prime attribute can be transitively dependent on a key in a 3NF relation
- A prime attribute can be transitively dependent on a key in a BCNF relation
- Any relation with two attributes is in BCNF
Correct Option: D
Statement (A) Any relation with two attributes is in BCNF is true as with the rules of BCNF, any relation with two attributes gets into Boyce codd normal form.
Statement (B) A relation in which every key has only one attribute is 2NF is true as 2NF allows only the relation where a key has only one attribute.
Statement (C) A prime attribute can be transitively dependent on a key in a 3NF relation is also true as prime attribute has to be transitively dependent on a key in 3NF.
Statement (D) A prime attribute can be transitively dependent on a key in a BCNF relation is false as this is a feature of 3NF and not BCNF.