Multiple choice

Which of the following statements is false?

  1. A table in 1st normal form contains no repeating groups.

  2. A table in 2nd normal form contains no partial functional dependency.

  3. 3 NF removes transitive functional dependency.

  4. 3 NF is equivalent to BCNF.

  5. BCNF is a special case of 3 NF.

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

This option is false as 3NF and BCNF are equivalent only if BCNF contains only one candidate key.