Question: Changing the employee whose ID = 8 to 1 2 in the table EMPLOYEE. If it is rejected, explain. EMPLOYEE ( EmployeeID, EmployeeName, SupervisorID, DepartmentID

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);

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!