For this assignment, everyone needs their PostgreSQL account. Your
account name will be your Westmont email address. Your password
will be the final six (6) digits of your
student ID number.
Project 2 Deliverable
Please attach a copy of your E/R schema from the Part 1 of your
If you have modified your design because of my feedback (or any other
reason), please hand in the modified design instead; the new design
not be graded but will be compared with your relational design.
Use the method for translating an E/R diagram to relations
class and the text to produce a set of relations from your E/R design.
Specify your relational schema using the notation of Section 3.1.2,
and please be sure to underline key attributes.
Are there any flaws in the relational database
schema you get from part (b)?
Are there opportunities to combine relations without introducing
If so, indicate which, and if not, indicate there are none.
Are there examples of non-BCNF relation schemas?
If so, do you want to decompose them?
For each opportunity to combine or decompose
relations, decide whether or not to do
so, and explain your reasoning briefly (e.g., explain what queries you
expect will be typical for your database, and tell how the design you
pick facilitates them).
Is there anything
you still don't 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
a bit, so it's worth spending some time to make sure you're happy with
Login to PostgreSQL using your favorite SQL client.
Try some simple commands, such as help or table (relation) creation. It
is important that people try logging in as soon as possible.
Don't forget to save a copy of your work for reference as
do Part 3 of the Database Project.
of the material for the project descriptions and assignments has been
taken from Professor Ullman's website.