Database-Management-System
May 14, 2024Database-Management-System
May 14, 2024Database-Management-System
|
Question 894
|
BCNF is not used for cases where a relation has
|
Two (or more) candidate keys
|
|
|
Two candidate keys and composite
|
|
|
The candidate key overlap
|
|
|
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.
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.
Transformation into Boyce-Codd normal form deals with the problem of overlapping keys.