Open In App

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

Like Article
Like
Save
Share
Report

Identify the minimal key for relational scheme R(A, B, C, D, E) with functional dependencies F = {A → B, B → C, AC → D}
(A) A
(B) AE
(C) BE
(D) CE


Answer: (B)

Explanation: A+ = ABCD
But we can’t derive E from A, so We have to add E i A
I.e. AE+ = ABCDE.
So, option (B) is correct.

Quiz of this Question


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