UMBC              Fall 2004
CMSC661        Principles of Database Systems
 

Homework2 -- Due October 11th  beginning of class. No late homeworks accepted.

All questions are from H. G-M

  1. Exercise 6.3.1 a, b, c, d, e, f (30 points)
  2. Exercise 6.4.6 a, b, c, d, e (25 points)
  3. Exercise 3.5.2 (10 points)
  4. Exercise 3.6.1 a, b, c (15 points)
  5. Exercise 3.6.2 (10 points)
  6. Find the minimal cover for the schema R = (A,B,C,D,E) and the set  F of functional dependencies is : (10 points)
        {A --> BC, ACD --> E, B --> D, C --> D,  AB --> E, E --> BC}