CPSC 310/603
Spring 2007

General Instructions:

  1. The numbers refer to the exercises at the end of the listed section in the textbook.

  2. TYPE your solutions. Grading will be based on correctness, clarity, and whether your solution is of the appropriate length.

  3. Don't forget to acknowledge all sources of assistance. Unless otherwise instructed, you must write up your homework on your own. Turn in your homework together with this cover sheet.

  4. Homework is always due at the beginning of class. Change in turn-in procedure: Please turn in paper copy of the entire assignment plus cover sheet to class. Do *not* use the turn-in program. I apologize for the confusion.

  5. You are encouraged to work extra problems: the more you work, the more you will learn. You can check your work with the starred ones (solutions are on the textbook webpage).

[Homework 1] [Homework 2] [Homework 3] [Homework 4] [Homework 5] [Homework 6] [Homework 7]

Homework 1. Due Thursday, Sep 6, 2007, 12:45 PM

Homework 2. Due Thursday, Sep 20, 2007, 12:45 PM

Homework 3. Due Thursday, Oct 4, 2007, 12:45 PM

Homework 4. Due Tuesday, Oct 16, 2007, 12:45 PM

Make a MySQL database containing the data given in Figures 5.10 and 5.11. Write MySQL queries for all the exercises below and execute the queries on your database. Print out the console output (including your query and the result of the query), label the problem numbers, and turn in the hard copy.

Homework 5. Due Thursday, Nov 1, 2007, 12:45 PM

Homework 6. Due Thursday, Nov 15, 2007, 12:45 PM

Homework 7. Due Tuesday, Dec 4, 2007, 12:45 PM