Instructions: Write your answer neatly and concisely.

only standard, conventional symbols in the design diagrams.

Illegible scribbles or unclear solutions will result in lost

credit. Submit your answers in pdf$,$ doc, docs, or jpg to the

Assignment in Websources by the due date.

Translate the following ER diagram into a relational schema,

and show the SQL statements needed to create the relations. If

your translation cannot capture any constraints in the ER

diagram, explain why.