Homework #3 :Due date 4/11 in class : Hardcopy

1. Consider a scheme R (A,B,C,D,E) and the two set of functional dependencies. Are the two sets F1 and F2 equivalent?

F1 : A-->B, AB--> C, D--> AC, D --> E

F2 : A--> BC , D--> AE

2. Consider the schema R (A,B,C,D,E,F).

AB--> C, C --> A, BC -->D, AC D--> B

BE-->C, CE-->FA, CF-->BD, D-->EF

a. Find the closure.

b. Find the set candidate keys.

Show all the steps.

Previous slide

Back to first slide

View graphic version