Database Principles
25440/01 Fall 2001
Class 27: Dec. 6, 2001

Next design step. Please try to complete by next Tuesday.
Submit your solution for the following problem by inserting the required tables and SQL procedure into the database, and sending me an e-mail that identifies the material you have created.

Problem 3.
Populate the car, customer, and any additional tables you need to produce the report described below, with at least fifteen rows each.
Produce a report that gives:
For each mechanic, a list of the customers for whom that mechanic performed services. For each service, identify the car and the service that the mechanic performed.

Problem 4.
Populate the customer, vendor, and any additional tables you need to produce the report described below, with at least fifteen rows each.
Produce a report that gives:
For each vendor, a list of the customers who have rented movies supplied by that vendor. For each rental, identify the movie, the type of the movie, and amount the customer paid for the rental.

Problem 6.
Populate the customer, vendor, and any additional tables you need to produce the report described below, with at least fifteen rows each.
Produce a report that gives:
For each vendor, a list of the customers who have purchased products supplied by that vendor. For each purchase, identify the product, and the amount the customer paid for the product.

Problem 8.
Populate the truck, mechanic, and any additional tables you need to produce the report described below, with at least fifteen rows each. (You may have to assume more trucks than the number described in the book's description of the problem.)
Produce a report that gives:
For each mechanic, a list of trucks that were serviced by that mechanic. For each service, identify the parts the mechanic used and the time spent to install the part or perform the service.