Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 to 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 NOT NULL,
SupervisorID INT DEFAULT
DepartmentID INT. DEFAULT
FOREIGN KEY SupervisorID REFERENCES EMPLOYEE EmployeeID
ON DELETE SET DEFAULT
FOREIGN KEY DepartmentID REFERENCES DEPARTMENTDepartmentID
ON UPDATE SET NULL ;
CREATE TABLE PROJECT
ProjectID INT PRIMARY KEY,
EmployeeID INT DEFAULT
FOREIGN KEY EmployeeID REFERENCES EMPLOYEE EmployeeID
ON DELETE SET NULL
ON UPDATE CASCADE ;
CREATE TABLE DEPARTMENT
DepartmentID INT PRIMARY KEY,
DepartmentName VARCHAR;
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started