Homework 3

Construct SQL SELECT statements to explore a database.

This homework is worth 40 points.

Goals

When you have completed this homework you should

Understand the basics of SQL SELECT statements.
Be able to employ basic SQL SELECT statements to explore a database.

Assignment

(20) Points: Create SQL statement which perform the queries described in the Queen Anne Curiosity Ship Problem, pages 106-112. I have modified Kroenke's install scripts for this database and placed them in my directory. The tables now all begin with QACS_. To install the database do the following:

mysql> source /home/CS/dbennett/313/ch2/QACS_tables.sql;
mysql> source /home/CS/dbennett/313/ch2/QACS_data.sql;

Please run your commands and examine the results carefully to see that the command actually performed the query indicated. Syntactically correct commands which fail to perform the query are worth no points.

The queries you are to perform are on pages 108-111 and are labeled A-T.

Please type all of your SQL statements using the format demonstrated in the book and in the class notes. I will deduct points for sloppy or poorly formatted work.

This homework should be printed and turned in at the beginning of class.