CSC 443 Data Base Management Systems

Dr. R. M. Siegfried

Assignment 11 - Creating And Using Views

Due Monday, December 9, 2013

Using the database that we have already seen in Assignment #6, create two views:

1. A view that includes:
   • the first name, middle initial and last name of the employee
   • the employee's address
   • the employee's salary
   • first and last name of the employee's supervisor
   • the name of the employee's department
2. A view that includes:
   • The name, number and location of the project
   • The name of the department that is responsible for the project
   • The name of the department's supervisor

Also, write SELECT statements to answer the following queries:

1. List the full names and salaries for everyone working for Franklin Wong.
2. List the full names and salaries for every in the Research Department.
3. List the average salaries for employees working for each of the departments.
4. List the total number of employees working on the ProductX project.
5. List the total number of employees working on each project.

[Back to the Assignment Page]