GATE | GATE-CS-2000 | Question 47

Given the following relation instance.

x  y  z
1  4  2
1  5  3
1  6  3
3  2  2  

Which of the following functional dependencies are satisfied by the instance? (GATE CS 2000)
(A) XY -> Z and Z -> Y
(B) YZ -> X and Y -> Z
(C) YZ -> X and X -> Z
(D) XZ -> Y and Y -> X


Answer: (B)

Explanation: See question 2 of https://www.geeksforgeeks.org/database-management-system-set-1/

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.