Question: fuestion Completion Status: indicate why it is invalid. (RESTRICT is the default option for delete) Figure 5.6 One possible database state for the COMPANY relational

 fuestion Completion Status: indicate why it is invalid. (RESTRICT is the
default option for delete) Figure 5.6 One possible database state for the
COMPANY relational database schema EMPLOYEE Fname Minit B John Franklin Alicia T
J S K Jennifer Lname Ssn Bdate Address Sex Salary Super_san Dno
Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 5 Wong
333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 5 Zelaya 999887777

fuestion Completion Status: indicate why it is invalid. (RESTRICT is the default option for delete) Figure 5.6 One possible database state for the COMPANY relational database schema EMPLOYEE Fname Minit B John Franklin Alicia T J S K Jennifer Lname Ssn Bdate Address Sex Salary Super_san Dno Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 5 Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 5 Zelaya 999887777 1968-01-19 3321 Castle Spring, TX F 25000 987654321 4 Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX F 43000 888665555 4 Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TXM 38000 333445555 5 English 453453453 1972-07-31 5631 Rice, Houston, TX F 25000 333445555 5 Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 987654321 888665555 1937-11-10 450 Stone, Houston, TX M Borg 55000 NULL 1 Ramesh 5 5 Joyce Ahmad 4 m into EMPLOYEE (b) Insert into PROJECT (c) Insert Into DEPARTMENT (d) Insert Into WORKS ON (e) Insert Into DEPENDENT. (t) Delete the WORKS ON tuples with Hours='null'. (9) Delete the EMPLOYEE tuple with SSN='888665555'. (h) Delete the PROJECT tuple with Pnumber=20. Modify the Dnumber. Mgr_ssn and Mgr_start_date of the DEPARTMENT tuple with DNUMBER-5 to '6', 123456789 and 1988-10-10', respectively 0) Modify the SUPERSSN attribute of the EMPLOYEE tuple with SSN-'999887777 to 999887777

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!