CSC 335 - Database System Concepts
Homework # 4
Due Date: April 5, 2011
Total Possible Points: 100

Students will work in groups on this assignment. Each group will consist of the same students who are working on the same project. Design a database for your project. Your design will include an E-R diagram, a set of relation schemas (which are derived from the E-R diagram), and a list of constraints, including primary key and foreign key constraints (show this using a schema diagram). Make sure to use descriptive attribute names and to provide as much details as possible so that a person who has no idea about your project will fully understand it from your descriptions. 

Each group needs to turn in one copy for the solution of this assignment. Make sure to write the names of all the students who worked on the assignment. If a student does not participate satisfactorily on the assignment, pleasse let the instructor know and the grade they receive will reflect that.