Background Material

0. Text: Chapter 13 (not present in old book)

1. SQL Syntax

2. Ray Williams' slides

3. Azhar Iqbal's slides

4. Bryson Payne's slides

5. SQL FAQ

6. MySQL Reference Manual

Assignment

1. (INDIVIDUAL) (3 points) Create a database in MySQL. You can create the database for one of the following two options:

a) Keeping data your project uses (e.g. to hold products if you're making a web-store).
b) A car sale.

Try to have at least 4 tables, with each table having a few columns.

2. (INDIVIDUAL) (1 point) Write an interface to your database (in PHP or CGI). Users should be able to add new data (new products), remove existing data (/products) and change existing data.

3. (1 Point) Describe what users told you in your beta test and in their reviews on your Project Description page. Say what you will or did change (if anything) based on theseand why or why not.