CSci 275 TDA Part 2: Relational Database Design
Due: Tuesday, 12 March (12 February 2013) at the beginning of class.
Please attach a revised copy of your E/R schema from the first deliverable.
Even if you have modified your design (due to feedback or any other reason),
the new design will not be graded but will be compared with your relational design.
- (25 points)
Use the method for translating an E/R diagram to relations described in class
to produce a set of relations from your E/R design.
Specify your relational schema using the notation of
Relation-name(attribute1, attribute2, ..., Attributen).
Please be sure to underline primary key attributes and explicitly specify all other
integrity constraints that hold on your relations
(i.e. specify foreign key info (bold), data type info, value range, etc.).
- (25 points)
Are there opportunities to combine relations without introducing redundancy?
If so, indicate which relations, and if not, tell us there are none.
For each opportunity to combine or decompose relations, decide whether or not to do so, and
explain your reasoning briefly (e.g., tell what queries you expect will be typical for your
database, and tell how the design you pick facilitates them).
- (0 points)
Is there anything you still do not like about the schema
(e.g., attribute names, relation structure, duplicated information, etc.)?
If so, modify the relational schema to something you prefer.
You will be working with this schema quite a bit, so it's worth spending
some time to make sure you're happy with it.
Don't forget to save a copy of your TDA for reference as you complete the
next deliverable of the project.