Specify the following updates using the SQL update commands: -Insert <‘Robert’,‘

ID: 3891520 • Letter: S

Question

Specify the following updates using the SQL update commands:

-Insert <‘Robert’,‘F’,‘Scott’,‘943775543’,‘1972-06-21’,‘2365 Main St, Bellaire, TX’,M,58000,‘888665555’, 1> into EMPLOYEE.

-Insert <‘453453453’,‘John’,‘M’,‘1990-12-12’,‘spouse’> into DEPENDENT.

-Delete the WORKS_ON tuples with Essn = ‘333445555’.

-Modify the Mgr_ssn and Mgr_start_date of the DEPARTMENT tuple with Dnumber = 5 to ‘123456789’and ‘2007-10-01’, respectively.

-Modify the Hours attribute of the WORKS_ON tuple with Essn = ‘999887777’and Pno = 10 to ‘5.0’.

Hello there,

In the given question, only 2 updates commands are found, so i am writing update sql query for those updates command(modify), i.e. 4th and 5th.

so,

4.) UPDATE DEPARTMENT SET Mgr_ssn = '123456789', Mgr_start_date = '2007-10-01' where Dnumber = 5;

This query will update all the records where Dnumber is 5 with column Mgr_ssn and Mgr_start_date by mentioned values.

5. UPDATE WORKS_ON SET Hours = '5.0' where Essn = '999887777' and Pno = 10;

This query will update all the records where Pno is 10 and Essn = '999887777' with column Hours by mentioned values.

Hope, you got the solution, feel free to ask any doubt.

Thank you

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.