Skip to content
Related Articles

Related Articles

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

View Discussion
Improve Article
Save Article
Like Article
  • Last Updated : 01 May, 2018

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

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

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!