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 Select the correct answer from above options Interview Questions and Answers, Database Interview Questions and Answers for Freshers and Experience

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).