ER-Model
August 21, 2024Database-Management-System
| Question 36 |
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 36 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 36 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
Subscribe
Login
0 Comments