Database Management Homework Assignment 1

1. If you have not already done so, load SQL Server or some other SQL environment such as MySQL.  SQL Server Express Edition is available for free from Microsoft, but you can also get the full version from the Microsoft Academic Alliance.  If you already have access to this program, you may use it.

2. Load the "company" database linked on the main class page.

3. Write a SQL query (or view) that lists the total number of hours worked on each project and the name and location of the project.  Remember, this must be a single query, although it may be a compound query.

To hand in by February 9, 2011:

1. Your query as a text file so I can run it.  Use the naming convention below for the text file, too.

2. A screen shot of the output of your query as a .JPG file.

Hand this in through eLearning.