Addendum to CPS 430/542 Homework #4
Assigned: September 27
Due: October 4, 4:30pm, in class
- (5 points) Consider the following sets of
FDs over the relation R(A, B, C):
- F1 = {A → B, B → C}
- F2 = {A → B, A → C}
- F3 = {A → B, A B → C}
Identify all sets above which follow from a) F1
b) F2, and c) F3.
Which pairs of these sets of
FDs (F1 and F2, F2 and
F3, and
F1 and F3) are equivalent to each other?
- (5 points) Consider the following set of
FDs over the relation Widgets(source, destination, volume, weight):
source volume → weight
destination → weight
source volume → destination
- Give a minimal set of FDs equivalent to the set above.
- Give one key for the relation Widgets and prove it is a key.
- Any there any other keys? Give reasons.
|