Upload to the CS Homework system
on or before midnight on Monday, October 11
old: Monday, October 4.
(Typed, not handwritten. It should be plain text, MS Word,
Before you begin, write a one-paragraph summary of what your project application domain is. In other words, remind me of your project and what you promised to do in it. Also, if I gave you comments, corrections, or suggestions about Part 2 of your project, address those modifications first, before you proceed with Part 3. (If your ER diagram required change, you will need to submit the changed ER diagram as part of Part 3.)
To Do: Convert your ER diagram to relations. Do not normalize yet. (We have not covered database normalization in class yet.) Follow the procedures taught in class and described in the textbook. For your solution, submit a list of relation schemas. Write down the schema as a series of SQL "create table" commands, in correct syntax, as shown in textbook examples. (See Section 5.3.2, particularly page 159) Attach an up-to-date copy of your ER diagram (modified and corrected based on our comments, if required) to your answer.
What to turn in: Email or paper copies of ER diagram and resulting relations. (Relation definitions typed.) Including the ER diagram is required, so that I can verify that you did the conversion correctly. Identify your group by your project title and the team members. As always, note any additional constraints or restrictions that your domain possesses that are not reflected in your model.
Required but not graded: Include one sentence per group member summarizing each group member's contribution to Project Part 3. These sentences will be required in all project parts from here on. They are not for part of any student grades. They will be used to monitor group dynamics.