Question

Which-one ofthe following statements about normal forms is FALSE?

(a) BCNF is stricter than 3 NF

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

(c) Loss less, dependency – preserving decomposition into BCNF is always possible

(d) Any relation with two attributes is BCNF

The question was asked during an interview.

My question comes from Normal Forms in division Normalization of Database Management

Answer 1

Right answer is (c) Loss less, dependency – preserving decomposition into BCNF is always possible

Easiest explanation - We say that the decomposition is a lossless decomposition if there is no loss of information by replacing r (R) with two relation schemas r1(R1) andr2(R2).