Exercise

Using the Company Database to execute following query.

1.For every department located in Houston, list the name of the department, last name of the department manager and the name of the project(s) control by these departments(s).

2.Retrieve name(s) of the projects and the name of the controlling department that is located in Bellaire. Do not include projects that are controlled by Administration department.

3.List First names and project names of all employees who work on project(s) and have Smith as their last name. Also, include only those projects that are controlled by the department managed by an employee whose last name is Wong.

Final Relational Schema EMPLOYEE DEPARTMENT Dek Dname Dnumber Mgrssn Mgr start date DEPT LOCATIONS Dnumber Diccton PROJECT WORKS ON Ess Pro Hors DEPENDENT egenens omh Sex Bdate Relatenshp $8