CIS 339 Database Organization

Winter 2004

HW # 2

Due Date: Wednesday, January 28, 2004

Relation R (Emp, Proj, Mgr, Dept, Proj-leader, Cust, Task)
Key: Emp, Dept
FDs: Emp à Mgr, Mgr à Dept, Proj à Proj-leader
Proj-leader à Cust, Proj à Cust

Decompose it

· Into a lossy decomposition

· Into a lossless but not FD-preserving decomposition

· Into a lossless and FD-preserving decomposition

NOTE: Homework must be submitted by email to TA (Amul Chapla) by email (amulchapla@iit.edu) on/before 6:00pm Wednesday, January 28, 2004.