NIELIT 2016 DEC Scientist B (IT) - Section B: 44

Question

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

• A. BCNF is stricter than $3$NF.
• B. Lossless, dependency-preserving decomposition into BCNF is always possible.
• C. Lossless, dependency-preserving decomposition into $3$NF is always possible.
• D. Any relation with two attributes is BCNF.

Comments

Duplicate of: https://gateoverflow.in/1365/gate-cse-2005-question-29-ugcnet-june2015-iii-9 

Answer 1

Option B.Lossless,dependency preserving decomposition into BCNF is always possible

Lossless,dependency preserving decomposition into BCNF is not always possible.

Answer 2

Lossless,dependency preserving decomposition into BCNF is not always possible

it is always poosible in 3nf or lower level normal form .

so correct ans is : B