Question

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

(a) BCNF is stricter than 3NF

(b) Lossless, dependency-preserving decomposition into 3NF is always possible

(c) Lossless, dependency-preserving decomposition into BCNF is always possible

(d) Any relation with two attributes is in BCNF

The question was asked during a job interview.

I want to ask this question from Materialized Views in chapter Query Processing Techniques of Database Management

Answer 1

The correct answer is (c) Lossless, dependency-preserving decomposition into BCNF is always possible

For explanation: Achieving Lossless and dependency-preserving decomposition property into BCNF is difficult.