Question: ( 0 . 5 p ) Insert < 'Robert', ' F ' , 'Scott', ' 9 4 3 7 7 5 5 4 3

"(0.5p) Insert <'Robert', 'F', 'Scott', '943775543','1972-06-21','2365 Newcastle Rd, Bellaire, TX','M',58000,'888665555',1> into EMPLOYEE
(0.5p) Insert <'ProductA', 4, 'Bellaire', 2> into PROJECT
(0.5p) Insert <'Production', 4,'943775543','2007-10-01'> into DEPARTMENT
(0.5p) Insert <'677678989', NULL, '40.0'> into WORKS_ON
(0.5p) Insert <'453453453', 'John', 'M','1990-12-12', 'Spouse'> into DEPENDENT
(2p) Delete the WORKS_ON tuples with Essn ='333445555'
(2p) Delete the EMPLOYEE tuple with Ssn ='987654321'
(2p) Delete the PROJECT tuple with Pname = 'ProductX'
(1p) Modify the Mgr_ssn and Mgr_start_date of the DEPARTMENT tuple with Dnumber =5 to '123456789' and '2007-10-01', respectively
(0.5p) Modify the Super_ssn attribute of the EMPLOYEE tuple with Ssn ='999887777' to '943775543'"

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!