UGC-NET | UGC NET CS 2018 Dec – II | Question 49
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
Share your thoughts in the comments
Please Login to comment...