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

Normal Form MCQ - General Knowledge Question and Answer

Normalization is a database design technique which organizes tables in a manner that reduces redundancy and dependency of data. It divides larger tables into smaller tables and links them using relationships.

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


BCNF is stricter than 3 NF
Lossless, dependency -preserving decomposition into 3 NF is always possible
Loss less, dependency preserving decomposition into BCNF is always possible
Any relation with two attributes is BCNF

Answer:

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

Share Me: