Problem Description

The ER diagram shown in the following picture
mostly follows the description of data in the previous assignment,

Your Tasks:

First, translate the ER diagram to its equivalent relational schema. Clearly show the relations, the attributes, the primary keys and the foreign keys if there are any in the shcema. Note that the names of the relations and attributes don't need to be the same as the names used in the ER diagram. You can choose your own names as long as they are meaningful, easy to understand and not ambiguous.

Then, translate the relational schema to its equivalent physical schema. Write the SQL statements that can actually create these relations/tables in Oracle database system. Choose reasonable data types for the attributes/columns, and specify at least all the primary key and foreign key constraints.

How to Submit

Your solution should be presented as a text file or a PDF file.

Make your answer precise and concise. Make your document easily understandable.

You can submit your assignment solution using one of the following two ways:

• Submit a hard copy before the due date/time.
• Login to VIU Learn, submit your solution file(s) to A2 under CSCI 370's assessment and assignments tab.