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



My Personal Notes arrow_drop_up
Article Tags :

Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.