EMPLOYEE Table

Column Name	Data Type	Length
EMPID	Number	7
EMPNAME	Varchar2	25
DEPTID	Number	7

DEPARTMENT Table

Column Name	Data Type	Length
DEPTID	Number	7
DEPTNAME	Varchar2	25

After both tables are created,

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

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

3. 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.

Number 3 is where I am running into trouble, everything I have tried and even solutions that I have found on here have not helped.