Answered step by step
Verified Expert Solution
Link Copied!

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=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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intranet And Web Databases For Dummies

Authors: Paul Litwin

1st Edition

0764502212, 9780764502217

More Books

Students also viewed these Databases questions