Open In App

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

Like Article
Like
Save
Share
Report

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


Last Updated : 07 Jan, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads