Question: Specify the following queries in SQL on the COMPANY database. Show the result of each query. Retrieve the names of all employees in department 5

  1. Specify the following queries in SQL on the COMPANY database. Show the result of each query.
    1. Retrieve the names of all employees in department 5 who work more than 10 hours per week on the ProductX project.
    2. List the names of all employees who have a dependent with the same first name as themselves.
    3. Find the names of all employees who are directly supervised by Franklin Wong.

  1. Specify the following updates using the SQL update commands. Show the state of each relation after the update.

  1. Insert into EMPLOYEE.
  2. Insert <453453453,John,M,1990-12-12,spouse> into DEPENDENT.
  3. Delete the WORKS_ON tuples with Essn = 333445555.
  4. Modify the Mgr_ssn and Mgr_start_date of the DEPARTMENT tuple with Dnumber = 5 to 123456789and 2007-10-01, respectively.
  5. Modify the Hours attribute of the WORKS_ON tuple with Essn = 999887777and Pno = 10 to 5.0.

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 General Management Questions!