Write answers for each question with these two form:

QUERY BY EXAMPLE and RELATION ALGEBRA

1. Retrieve the name and address of all employees who work for the ‘Research’ department.

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. Find the names of employees who work on all the projects controlled by department number 5.

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. List the names of all employees with two or more dependents.

6. Retrieve the names of employees who have no dependents.

7. The names of managers who have at least one dependent.