TASKS:

Transform the EER model $($Appendix A in the following page$)$ to Relational tables, making sure you show all the steps. The final set of tables should contain necessary information such as table names, attribute names, primary keys $($underlined$)$ and foreign keys $($in italics$).$

$40\%$

a$)$ Implement the tables in the ORACLE Relational DBMS$.$ When creating tables make sure you choose appropriate data types for the attributes and specify any null$/$not null or other constraints whenever applicable.

b$)$ Write one insert statement for each of your tables using realistic data. Make sure you take into consideration all the necessary constraints.

$[30\%]$

Write all the $9$ steps and write the code for creating the tables