GATE 2017 Previous Year Paper Solution Question 14 – Computer Science

In this video, the question which was asked in the exam of GATE 2017, has been discussed.

Question :- 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 ?

1. V → W
V → X
Y → V
Y → Z

2. V → W
W → X
Y → V
Y → Z

3. V → W
V → X
Y → V
Y → X
Y → Z

4. V → W
W → X
Y → V
Y → X
Y → Z

Solution is given in the video.