CS 4250: Project Part 3


Hardcopy or email due at the start of class on Monday, October 10, 2016 (new). ((old deadline) Wednesday, October 5, 2016) (If hardcopy, typed, not handwritten. If email, it should be plain text, MS Word, or PDF, with subject line "cs4250 project part 3".)

Before you answer the following questions, 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.

Relations: 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 (Section 5.3.2, particularly page 159). Attach a 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, and to try to intercede in troubled groups (if any) before troubles get out of hand.


Last modified: September 14, 2016