-
The following functional dependencies hold true for the relational schema R{V,W,Xt Y,Z}
V → W
VW → X
Y → VX
Y → Z
Which of the following is irreducible equivalent for this set of functional dependencies?
-
- V → W
V → X
Y → V
Y → Z - V → W
W → X
Y → V
Y → Z - V → W
V → X
Y → V
Y → X
Y → Z
- V → W
W → X
Y → V
Y → X
Y → Z
- V → W
Correct Option: A
The given functional dependencies are for the relational schema R (V, W, X, Y, Z)
Where as, W is extraneous from (VW → X)
Where, (Y → X) is redundant functional dependence.
It is the minimal set that cover all the given functional dependencies and it is irreducible equivalent to this given F.D.
