SQL Practice #2

Due by Monday, November 12 at midnight

Last accepted with late days is Thursday, November 15 at midnight

Goal of assignment

The goal is for you to work with more sophisticated SQL queries.

What to do

The script found in the SQL practice 2.sql file.

You will use the same schema from assignment 1. Execute each SQL query. For each query tell what it does. I do not want a listing of the result. I want you to describe in English what it is doing. Part should be a description that a non-CS user of the database would understand. You are welcome to use any SQL references you want to determine what is going on. An example of a description could be "Find the highest paid employee who works outside the U.S." What I don't want is "Find the maximum salary of all entries in the Employee table where location <> U.S."

Working in groups

You may (and are even encouraged) to work in groups of up to three (3) students. You only need to turn in one solution for each group unless there is a problem. Place all group members names on the solution. All members of the group must know the details and reasoning of the solution. If only some members worked on and understand a particular problem solution then this should be noted on what you turn in by giving the name(s) of the people who accomplished the work for that problem.

Turning in your work

There is an assignment link on Moodle. Turn in a file with your answers. It can be in any reasonable format (PDF, RTF, MS Word, Open Office, Pages, ....).