EssayproSolutions

(Solved) : Consider Following Relational Schema Ddl Statements Tables Show Status Tables Following Op Q31044639 . . .

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

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

EMPLOYEE( EmployeeID, EmployeeName, SupervisorID, DepartmentID)

PROJECT (ProjectID, EmployeeID)

DEPARTMENT( Department ID, DepartmentName)

CREATE TABLE EMPLOYEE

( EmployeeID         INT PRIMARYKEY,

  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)

);

Here is the table. https://imgur.com/a/G5UZxKC

Expert Answer

---

Answer to Consider Following Relational Schema Ddl Statements Tables Show Status Tables Following Op Q31044639 . . .