Open In App

UGC-NET | UGC NET CS 2018 Dec – II | Question 49

Like Article
Like
Save
Share
Report

Consider the schema R=(A, B, C, D, E, F) on which the following functional dependencies hold :

A ➝ B
B,C ➝ D
E ➝ C
D ➝ A 

What are the candidate keys of R ?
(A) AEF, BEF and DEF
(B) AEF, BEF and BCF
(C) AE and BE
(D) AE, BE and DE


Answer: (A)

Explanation: Closure of attributes,

Closure of AEH, i.e. AEH+ = {ABCDEF}
Closure of BEH, i.e. BEH+ = {ABCDEF}
Closure of DEH, i.e. DEH+ = {ABCDEF} 

Option (A) is correct.

Quiz of this Question


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