Database-Management-System
August 21, 2024Database-Management-System
August 21, 2024Functional-Dependency
|
Question 6
|
Consider a relation R with five attributes V, W, X, Y, and Z. The following functional dependencies hold: VY → W, WX → Z, and ZY → V.
Which of the following is a candidate key for R?
|
VXZ
|
|
|
VXY
|
|
|
VWXY
|
|
|
VWXYZ
|
Question 6 Explanation:
As we can see that attribute XY do not appear in RHS of an FD, they need to be a part of key.
Candidate keys are
VXY, WXY, ZXY
Candidate keys are
VXY, WXY, ZXY
Correct Answer: B
Question 6 Explanation:
As we can see that attribute XY do not appear in RHS of an FD, they need to be a part of key.
Candidate keys are
VXY, WXY, ZXY
Candidate keys are
VXY, WXY, ZXY