The ER diagram shown in the following picture
mostly follows the description of data in the
previous assignment,
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.
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: