CSE2DBF Database Fundamentals - Assignment 1– Part 2

TASKS:

2. a) Write create table statements to implement the tables in the ORACLE Relational DBMS. When creating tables make sure you choose appropriate data types for the attributes, specify any null/not null or other constraints whenever applicable, and specify the primary and foreign keys.

b) Write at least one insert statement for each of your tables using realistic data. Make sure you take into consideration all the necessary constraints.  [40%]