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

Save