Gate2017 cs Q31

0. The following functional dependencies hold true for the relational schema R{V, W, X, Y, Z}:
V → W
VW → X
Y → VX
Y → Z
Which of the following is irreducible equivalent for this set of functional dependencies?

Answer
Comment
Array

Option : A
Explanation :
V → W,VW → X,Y → V,Y → X,Y → Z (W is extraneous)
V → W,V → X,Y → V,Y → X,Y → Z
∴ Y → X is redundant
∴ {V → W,V → X,Y → V,Y → Z}

Forgot your password?

I agree with the Terms.