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
- 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 who work more than 10 hours per week on the ProductX project.
- List the names of all employees who have a dependent with the same first name as themselves.
- Find the names of all employees who are directly supervised by Franklin Wong.
- Specify the following updates using the SQL update commands. Show the state of each relation after the update.
- Insert
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 123456789and 2007-10-01, respectively.
- 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
