next up previous
Next: About this document

centering17

  1. (5 pts) Prove the soundness of the psuedotransitivity rule using Armstrong's axioms.
  2. The following questions all refer to a relation scheme R = (A, B, C, D, E, G) and set of functional dependencies F = tex2html_wrap_inline29 .
    1. (3 pts) Find tex2html_wrap_inline31 in F.
    2. (10 pts) Find a candidate key for relations on scheme R, and show that your answer is a candidate key. (Hint: first show that your answer is a superkey, and then show that removing any attribute from your answer results in an attribute set that is no longer a superkey.)
    3. (10 pts) Find Ftex2html_wrap_inline35 , a canonical cover of F.




Tim Wahls
Tue Apr 1 13:45:57 EST 1997