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 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
Get step-by-step solutions from verified subject matter experts
