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.