You may discuss problems with other students in the class. However, each student must write up his or her own solution to each problem independently. That is, while you may formulate the solutions to problems in collaboration with classmates, you must be able to articulate the solutions on your own.
1. In Database Management Systems by Ramakrishnan and Gehrke, Chapter 15, exercise 15.2, pg. 452. If R is not in 3NF, give a lossless-join, dependency-preserving decomposition into a collection of 3NF relations. If R is in 3NF but is not in BCNF, give a lossless-join decompostion of it into a collection of BCNF relations.
2. Repeat Problem 1 above, but given only dependences A->B and ED->A (i.e. eliminating dependency BC->E).