Explanation: The relation in second normal form is also in first normal form and no partial dependencies on any column in primary key. 4. 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
Answer:A
Explanation: The relation in second normal form is also in first normal form and no partial dependencies on any column in primary key. 4. 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
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).