...
Database-Management-System
May 14, 2024
Database-Management-System
May 14, 2024
Database-Management-System
May 14, 2024
Database-Management-System
May 14, 2024

Database-Management-System

Question 894
BCNF is not used for cases where a relation has
A
Two (or more) candidate keys
B
Two candidate keys and composite
C
The candidate key overlap
D
Two mutually exclusive foreign keys
Question 894 Explanation: 
A relation is in Boyce-Codd normal form if all attributes which are determinants are also candidate keys.
Transformation into Boyce-Codd normal form deals with the problem of overlapping keys.
Correct Answer: D
Question 894 Explanation: 
A relation is in Boyce-Codd normal form if all attributes which are determinants are also candidate keys.
Transformation into Boyce-Codd normal form deals with the problem of overlapping keys.

Leave a Reply

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