Multiple choice

Which one of the following statements is FALSE?

  1. Any relation with two attributes is in BCNF.

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

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

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

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

(1) True, because any relation with 2 attributes is in BCNF. (2) True, because in 2NF non-prime attributes should fully functional dependent upon keys. (3) A prime attribute can functionally dependent on a key in 3 NF. (4) In BCNF, transitivity is eliminated.