Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the following relational schema DDL statements and tables. Show the status of each table after each of the following operations: d . Changing DepartmentID
Consider the following relational schema DDL statements and tables. Show the status of each
table after each of the following operations:
d Changing DepartmentID from to in the table DEPARTMENT. 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
EMPLOYEE
PROJECT
DEPARTMENT
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