Question
Data Science and Artificial Intelligence Question on Database Concepts
Given the relational schema R = (U, V, W, X, Y, Z) and the set of functional dependencies :
{U → V,U → W, WX → Y,WX → Z,V → X}
Which of the following functional dependencies can be derived from the above set ?
A
VW → YZ
B
WX → YZ
C
VW → U
D
VW → Y
Answer
VW → YZ
Explanation
Solution
The correct option is (A) : VW → YZ, (B) : WX → YZ and (D) : VW → Y.