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
-
Exercise 6.3.1 a, b, c, d, e, f (30 points)
-
Exercise 6.4.6 a, b, c, d, e (25 points)
-
Exercise 3.5.2 (10 points)
-
Exercise 3.6.1 a, b, c (15 points)
-
Exercise 3.6.2 (10 points)
-
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}