Homework

Download the Northwind database (northwind.mdb) and familiarize yourself with its contents. As you will see from the relationships screen, it is similar to the Acme database we use in the lectures. Create (and save) queries that do the following:

• Return the names of all the suppliers in the United States
• Return the names of all the suppliers in North America
• Return the names of the products in decreasing order of price
• Return all the orders in decreasing order of total price (ignoring the discount).
• Return the total number of customers

Save the queries under the names "query1", "query2", etc.

Personal Database Project

Write (and save) 3 interesting QBE queries for your project database. At least one of them should involve multiple tables and at least one should involve grouping/aggregation. Make these queries return something that a user of your database might actually want to know.

What to turn in

Use Knightvision to submit your two access databases (i.e., the northwind db with queries, and your personal database with queries).