GATE | GATE CS 1999 | Question 24

Let R = ( A, B, C, D, E, F ) be a relation scheme 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: To check find the closure for all
{CD} = {CDF}
{EC} = {ECDAFB} Only this is the key because it drives all attributes.
{AE} = {AEB}
{AC} = {ACBF}

Hence, Option (B) is Correct.

Quiz of this Question

My Personal Notes arrow_drop_up

Save