Open In App

UGC-NET | UGC NET CS 2015 Dec – II | Question 20

Like Article
Like
Save
Share
Report

A relation R = {A, B, C, D, E, F,G} is given with following set of functional dependencies:
F = {AD → E, BE → F, B → C, AF → G}
Which of the following is a candidate key ?

(A) A
(B) AB
(C) ABC
(D) ABD


Answer: (D)

Explanation: [AD]+ = ADE.
[BE]+ = BCEF.
[B]+ = BC.
[AF]+ = AFG.
Nothing drives all the attributes, but if We add B in first key i.e. [ADB] then it will give all the attribute [ADB]+ = ABCDEFG.
So, option (D) is correct.


Quiz of this Question


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