CSC 443 Data Base Management Systems

Dr. R. M. Siegfried

Assignment 8 - More queries on the Company data tables.

Due Wednesday, November 6, 2013

Using the database created in Assignment #6, perform the following queries in MySQL on Panther:

1. List the first name, last name, Supervisor's first and last name, Departmnt number and the average salary for everyone in Administration
2. For every the employee with a dependent, list the dependent's first name, the employee's last name, and relation to the employee.
3. List the name of employees with a dependent named "Alice" and the relationship to the employee.
4. List everyone who works in Research (name and salary).
5. For each project, list project name, location, department and the superior of everyone working on that project.

[Back to the Assignment Page]