Open In App

GATE | GATE CS 1999 | Question 24

Like Article
Like
Save
Share
Report

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


Last Updated : 24 Oct, 2018
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads