Open In App

GATE | Sudo GATE 2020 Mock II (10 January 2019) | Question 15

Consider the relational schema R = {P, Q, R, S, T, U, V, W} and the set of functional dependencies FD:

FD = { Q → U, U → V, PQ → WST, SU → TR, VT → RW, R → W } 

Which of the following is a minimum cover of the FD ?
(A) { Q → U, U → V, P Q → S, SU → T, SU → R, VT → R, VT → W, R → W }
(B) { Q → U, U → V, PQ → S, SU → T, PQ → W, VT → R, PQ → T, R → W }
(C) { Q → U, U → V, PQ → S, SU → T, VT → R, R → W }
(D) { Q → U, U → V, PQ → S, SU → T, SU → R, VT → R, PQ → T, R → W }

Answer: (C)
Explanation: Option (C) is correct.
Quiz of this Question

Article Tags :