...
Database-Management-System
August 29, 2024
Database-Management-System
August 29, 2024
Database-Management-System
August 29, 2024
Database-Management-System
August 29, 2024

UGC NET CS 2015 June Paper-3

Question 9
Select the ‘False’ statement from the following statements about Normal Forms:
A
Lossless preserving decomposition into 3NF is always possible
B
Lossless preserving decomposition into BCNF is always possible
C
Any Relation with two attributes is in BCNF
D
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.
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.

Leave a Reply

Your email address will not be published. Required fields are marked *