Tuesday 23 June 2015

Q20,p2,d14. 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->B
B->C
Then inferred A->C.
A->d
As we now A->c .
E can not be derived by A. hence AE.can derive all  the attributes

1 comment:

Note: only a member of this blog may post a comment.