ISRO | ISRO CS 2015 | Question 20

Let R = (A, B, C, D, E, F) be a relation schema with the following dependencies C->F, E->A, EC->D, A->B. Which of the following is a key of R?
(A) CD
(B) EC
(C) AE
(D) AC


Answer: (B)

Explanation: Functional Dependencies of R = C->F, E->A, EC->D, A->B
Through the attributes C and E, we get all other attributes present in R.
So, EC is the key of R.

Quiz of this Question
Please comment below if you find anything wrong in the above post



My Personal Notes arrow_drop_up
Article Tags :

1


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