Question: 1 ) Insert < 'Robert', ' F ' , 'Scott', ' 6 6 6 8 8 4 4 4 4 ' , ' 1 9
Insert 'Robert', F 'Scott', Newcastle Rd Bellaire, TX M into EMPLOYEE.
Insert 'ProductA', 'Bellaire', into PROJECT.
Insert 'Production', null, into DEPARTMENT.
Insert into WORKSON
Insert 'John', M 'SPOUSE' into DEPENDENT.
Delete the WORKSON tuples with Hours 'null'.
Delete the EMPLOYEE tuple with SSN
Delete the PROJECT tuple with Pnumber
Modify the Dnumber, Mgrssn and Mgrstartdate of the DEPARTMENT tuple with DNUMBER to and respectively.
Modify the SUPERSSN attribute of the EMPLOYEE tuple with SSN to
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
