Database Help:

Specify the following queries in SQL on the COMPANY relational database schema shown in Figure 3.5. Show the result of each query if it is applied to the COMPANY database in Figure 3.6.

d. For each project, list the project name and the total hours per week (by all employees) spent on that project.

f. Retrieve the names of all employees who do not work any project

i. Find the names and addresses of all employees who do not work on at least one porject located in Houston but whose department has no location in Houston.

j. List the last names of all department managers who have no dependents.

EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Super_ssn Dno DEPARTMENT Dname Dnumber Mgr ssn Mgr start date DEPT LOCATIONS Dnumber Dlocation PROJECT PnamePnumber Plocation Dnum WORKS ON Essn Pno Hours Figure 3.5 Schema diagram for the COMPANY relational database schema. DEPENDENT Essn Dependent_nameSx Bdate Relationship