466 assignment 5
Please be neat and make it a word document . Also the SQL file is the most important!!!! Please note the
What to turn in?
The ER diagram that you have designed. This should be in a common image format, or a PDF. It may be hand drawn, but
must be legible for credit to be awarded.
▶ A second page like the one from the first ER diagram assignment, with all of the entities, relationships and attributes from
the ER diagram listed and described.
▶ The relational schema resulting from your ER diagram, in the format discussed in lectures. Primary keys need to be underlined, and foreign keys identified in a clear way.
▶ A text file, dayspa.sql with valid SQL CREATE TABLE statements to create each of the relations for your database. Do not forget the foreign key constraint.