Which one of the following statements about normal forms

Home » Database » Database miscellaneous » Question

Which one of the following statements about normal forms is false?

1. BCNF is stricter than 3 NF
2. Lossless, dependency-preserving decomposition into 3NF is always possible
3. Lossless, dependency-preserving decomposition into BCNF is always possible
4. Any relation with two attributes is in BCNF

Correct Option: C

The statement false is Lossless, dependencypreserving decomposition into BCNF is always possible.
Lossless, dependency preserving decomposition is possible in certain cases only. It is important to note that BCNF is not dependency preserving in all cases but in some cases only.