Copyright © T. H. Merrett

COMP 612           Principles of Database Programming             Week 1

				Assignment 1.

1. Get full details of all owners with names beginning with 'M'.
   (name, address, phone)

2. Get names of owners of cars made by Ford and subsidiaries of Ford.

3. Get names of owners of yellow cars.

4. Get names of owners of cars that are the same colour as some car
   owned by M. G. Tardif ('TARDIF G'). Do it also for 'WALKDEN M E'.

5. For each model made by Ford, get the names and addresses of all owners
   of such a model. (This is the same as (2), but add models and addresses,
   and show the result in groups by model.)

6. Get model names for all models such that no car of that model is yellow.

7. Get model names for all models such that, for every colour, there is a
   car of that model which is that colour. (That is, names of models that
   come in all colours.)

8. Get model names for all models such that, for every colour for which
   there is a Chevrolet Chevelle of that colour, there is a car of that model
   which is that colour. (That is, models that come in _all_ Chevelle
   colours.)

For future reference, record the cpu and I/O times needed to answer these
queries. (Total time for all eight queries is of special interest.)

Do this assignment in the teams that were set up in class.
This is the only group assignment in the course.