October 3, 2023
October 3, 2023
October 3, 2023
Functional-Dependency
October 3, 2023
 Question 91

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

 A BCNF is stricter than 3NF B Lossless, dependency-preserving decomposition into 3NF is always possible C Lossless, dependency-preserving decomposition into BCNF is always possible D Any relation with two attributes is in BCNF
Question 91 Explanation:
Option A: BCNF is stricter than 3NF. In this all redundancy based on functional dependency has been removed.
Option B: Lossless, dependency preserving decomposition into 3NF is always possible.
Option C: It is false.
It is not possible to have dependency preserving in BCNF decomposition.
→ Let take an example, 3NF can’t be decomposed into BCNF.
Option D: It is true.
Let consider two attributes (X, Y).
If (X→Y), X is a candidate key. It is in BCNF and vice-versa.
Question 91 Explanation:
Option A: BCNF is stricter than 3NF. In this all redundancy based on functional dependency has been removed.
Option B: Lossless, dependency preserving decomposition into 3NF is always possible.
Option C: It is false.
It is not possible to have dependency preserving in BCNF decomposition.
→ Let take an example, 3NF can’t be decomposed into BCNF.
Option D: It is true.
Let consider two attributes (X, Y).
If (X→Y), X is a candidate key. It is in BCNF and vice-versa.
Article Rating
Subscribe
Notify of
Inline Feedbacks
0