Consider the following relational schema DDL statements and tables. Show the status of each

table after each of the following operations:

c$.$ Delete the employee whose ID $=1$ If it is rejected, explain.

EMPLOYEE$($ EmployeeID, EmployeeName, SupervisorID, DepartmentID$)$

PROJECT $($ProjectID$,$ EmployeeID$)$

DEPARTMENT$($ Department ID$,$ DepartmentName$)$

CREATE TABLE EMPLOYEE

$($ EmployeeID INT PRIMARY KEY,

EmployeeName VARCHAR$(50)$ NOT NULL,

SupervisorID INT DEFAULT $9,$

DepartmentID INT. DEFAULT $6,$

FOREIGN KEY $($SupervisorID$)$ REFERENCES EMPLOYEE $($EmployeeID$)$

ON DELETE SET DEFAULT,

FOREIGN KEY $($DepartmentID$)$ REFERENCES DEPARTMENT$($DepartmentID$)$

ON UPDATE SET NULL$)$;

CREATE TABLE PROJECT $($

ProjectID INT PRIMARY KEY,

EmployeeID INT DEFAULT $9,$

FOREIGN KEY $($EmployeeID$)$ REFERENCES EMPLOYEE $($EmployeeID$)$

ON DELETE SET NULL

ON UPDATE CASCADE $)$;

CREATE TABLE DEPARTMENT$($

DepartmentID INT PRIMARY KEY,

DepartmentName VARCHAR$(50)$

EMPLOYEE

PROJECT

DEPARTMENT