C M S I 4 8 6
IN T R O D U C T I O N T O DA T A B A S E SY S T E M S
Fall 2005
Assignment 1117
This assignment is all about functional dependencies, normal forms, and decompositions. Part of it is
pure practice; the other part is application to your specific project.
Not for Submission
Read Chapter 7 in SKS.
For Submission
Submit the following on hardcopy. While not required for submission, presumably any database design
changes that you make in this assignment should be reflected in your project DAO code:
1. Exercise 7.1 in SKS.
2. Exercise 7.3 in SKS.
3. Exercise 7.5 in SKS.
4. Exercise 7.20 in SKS.
5. List the functional dependencies in your database project.
6. Based on this list, modify your database project’s relational database schema so that, as much
as possible, it is in BCNF, lossless, and dependency-preserving. If it is impossible to accom-
plish all three, either use 3NF or explain the dependency or dependencies that cannot be han-
dled. Submit the new relational database diagram.
