Please help. Q2. (60 points) Consider the following relational schema status of

Question

Please help.

Q2. (60 points) Consider the following relational schema status of the above tables after eachn reatioal schema, DDL statements and tables. Show the the tollowing operations. a. Inserting a new project: 7,9 into the Table PRoECT. If it is rejected, explain. EMPLOYER EmployeelD, EmployeeName, SuperviscelD), Departn PROJECT (ProjectID, EmployeelD) DEPARTMENTC Department ID, DepertmentName) CREATE TABLE EMPLOYEE ( EmployeelD INTPRIMARY KEY EmployeeName VARCHARIS0) NOT NULL SupervisorlD INT DEFAULT 9, DepartmentID INT FOREION KEY (SupervisortD) REFERENCES EMPLOYEE (EmployeeID) ON DELETE CASCADE ON UPDATE SET DEFAULT CREATE TABLE PROJECT ProjectTD INT PRIMARY KEY EmployeeID INT DEFAULT9 FOREIGN KEY (EmployeelD) REFERENCES EMPLOYEE (EmployeelD) ON DELETE SET NULL CREATE TABLE DEPARTMENT DepartmentID INT PRIMARY KEY, DepartmentName VARCHARIS0) EMPLOYEE EmployeeName Supervisorll EmployeeID NULL PROJECT ProjectiD ID DEPARTMENT epartmentName DepartmentlL

Explanation / Answer

After inserting a new project: 7, 9 into the Table PROJECT, the status of the tables:

EMPLOYEE:

PROJECT:

DEPARTMENT:

Please notice that the new project: 7, 9 has been now inserted into the PROJECT table and all other tables have the same status.

Note: If the insertion would get rejected, then there can be two cases:

EmployeeID EmployeeName SupervisorID DepartmentID 6 A 7 6 7 B 1 6 1 C 8 7 8 D 6 3 9 E NULL 6

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---