Q$2.(35$ points$)$ Consider the following relational schema DDL statements and tables. Show the

status of each table after each of the following operations:

a$.$ Changing the employee whose $ID=8$ to $12$ in the table EMPLOYEE. 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