Homework

As with the last project, download the Northwind database (H:/local/cpsc/341/northwind.mdb or northwind.mdb) and re-familiarize yourself with its contents. Write SQL queries that do the following:

• Return a list of all the category names.
• Return the company names of all the customers from London, UK.
• Return the fullnames of the employees, alphabetized by last, then first name.
• Return the order ID, customer name, and the names of the products for each customer order
• Return the number of products from each category.

Here, you'll just email me the SQL commands, rather than saving them as queries in the database.

Personal Database Project

Write 3 interesting SQL queries for your project database. One of them should involve multiple tables and one should involve grouping/aggregation. Make these queries return something that a user of your database may actually want to know, and make them different from the three queries you turned in in project #4.

What to turn in:

Use Knightvision to submit your SQL commands. Submit them in text form in an attached Word file.