Question: Figure 3.6 1) Query 1. Retrieve the name and address of all employees who work for the 'Research' department. 2) Query 2. For every project


Figure 3.6 1) Query 1. Retrieve the name and address of all employees who work for the 'Research' department. 2) Query 2. For every project located in 'Stafford', list the project number, the controlling department number, and the department manager's last name, address, and birth date. 3) Query 3. Find the names of employees who work on all the projects controlled by department number 5. 4) Query 4. Make a list of project numbers for projects that involve an employee whose last name is 'Smith', either as a worker or as a manager of the department that controls the project. 5) Query 5. List the names of all employees with two or more dependents. 6) Query 6. Retrieve the names of employees who have no dependents. 7) Query 7. List the names of managers who have at least one dependent
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
