Hardcopy or email due at the start of class on Monday, October 14. (If hardcopy, typed, not handwritten. If email, it should be plain text, MS Word, or PDF, with subject line "cs4250 project part 3".)
(Note: if homework is emailed, it must be all computer-program created. SQL typed, diagrams drawn with software. Photographs of hand-drawn material are not acceptable.)
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.
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.