December2015 Cs Q20

0. 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 ?

Answer
Comment
Array

Option : 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.

Forgot your password?

I agree with the Terms.