Question: 1 ) Insert < 'Robert', ' F ' , 'Scott', ' 6 6 6 8 8 4 4 4 4 ' , ' 1 9

1) Insert < 'Robert', 'F', 'Scott', '666884444','1942-06-22','2365 Newcastle Rd, Bellaire, TX', M,58000,'888665555',1> into EMPLOYEE.
(2) Insert < 'ProductA', 4, 'Bellaire', 1> into PROJECT.
(3) Insert < 'Production', null, '943775543','1988-10-18'> into DEPARTMENT.
(4) Insert <'888665555',20,'40.0'> into WORKS_ON.
(5) Insert <'453453453', 'John', M,'1988-01-10', 'SPOUSE' > into DEPENDENT.
(6) Delete the WORKS_ON tuples with Hours= 'null'.
(7) Delete the EMPLOYEE tuple with SSN='888665555'.
(8) Delete the PROJECT tuple with Pnumber='20'.
(9) Modify the Dnumber, Mgr_ssn and Mgr_start_date of the DEPARTMENT tuple with DNUMBER=5 to 6,'123456789' and '1988-10-10', respectively.
(10) 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 Programming Questions!