Consider the following relational schema, DDL statements and tables. Show the status of the above tables after each of the following operations:

EMPLOYEE( EmployeeID, EmployeeName, SupervisorID, Department ID)

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,

FOREIGN KEY (SupervisorID) REFERENCES EMPLOYEE (EmployeeID)

ON DELETE SET NULL ON UPDATE SET DEFAULT

);

CREATE TABLE PROJECT (

ProjectID INT PRIMARY KEY,

EmployeeID INT DEFAULT 9,

FOREIGN KEY (EmployeeID) REFERENCES EMPLOYEE (EmployeeID)

ON DELETE SET NULL );

CREATE TABLE DEPARTMENT(

DepartmentID INT PRIMARY KEY,

DepartmentName VARCHAR(50)

);

EMPLOYEE

EmployeeID	EmployeeName	SupervisorID	DepartmentID
6	A	7	6
7	B	1	6
1	C	8	7
8	D	6	3
9	E	NULL	6

PROJECT

ProjectID	EmployeeID
1	7
2	7
3	1
4	8
5	7
6	1

DEPARTMENT

DepartmentID	DepartmentName
3	X
6	Y
7	Z

a. Inserting a new project: 7, Null into the Table PROJECT. If it is rejected, explain.

b. Inserting a new employee: 30, F, 6, 9 into the Table EMPLOYEE. If it is rejected, explain

c. Delete the employee with ID = 1 from the Table EMPLOYEE .If it is rejected, explain.

d.Changing DepartmentID in the Table Employee from 7 to 3. If it is rejected, explain

e. Changing EmployeeID in the table PROJECT whose= ID = 8 to 9. If it is rejected, explain.