Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024UGC NET CS 2015 June Paper-3
| Question 9 |
Select the ‘False’ statement from the following statements about Normal Forms:
| Lossless preserving decomposition into 3NF is always possible | |
| Lossless preserving decomposition into BCNF is always possible | |
| Any Relation with two attributes is in BCNF | |
| BCNF is stronger than 3NF |
Question 9 Explanation:
Option(A) is true because 3NF preserves lossless decomposition and functional dependency.
Option(B) is false because BCNF ensures lossless decomposition but do not preserves functional dependency.
Option(C) is true because Any Relation with two attributes is in BCNF
Option(D) is true because BCNF ensure less number of duplicate values in a relation than 3NF.
Option(B) is false because BCNF ensures lossless decomposition but do not preserves functional dependency.
Option(C) is true because Any Relation with two attributes is in BCNF
Option(D) is true because BCNF ensure less number of duplicate values in a relation than 3NF.
Correct Answer: B
Question 9 Explanation:
Option(A) is true because 3NF preserves lossless decomposition and functional dependency.
Option(B) is false because BCNF ensures lossless decomposition but do not preserves functional dependency.
Option(C) is true because Any Relation with two attributes is in BCNF
Option(D) is true because BCNF ensure less number of duplicate values in a relation than 3NF.
Option(B) is false because BCNF ensures lossless decomposition but do not preserves functional dependency.
Option(C) is true because Any Relation with two attributes is in BCNF
Option(D) is true because BCNF ensure less number of duplicate values in a relation than 3NF.