7.

a. Create a table named EMPLOYEE based on the following properties: Column Name Data Type Length EMPID Number 7 EMPNAME Varchar2 25 DEPTID Number 7

b. Create a table named DEPARTMENT based on the following properties: Column Name Data Type Length DEPTID Number 7 DEPTNAME Varchar2 25

c. After both tables are created,

a1. Add a PRIMARY KEY constraint to the EMPLOYEE table using the EMPID column.

b1. Add a PRIMARY KEY constraint to the DEPARTMENT table using the DEPTID column.

c1. Add a FOREIGN KEY reference on the EMPLOYEE table so that if a department is deleted from the DEPARTMENT table, any employees in the EMPLOYEE table will automatically be deleted also.