Homework 2
CS122, Fall 2011


Due: Wednesday, November 23

Please put your SQL statements in three script files hw2-1.sql, hw2-2.sql, and hw2-3.sql, and upload them to CSNS. Note that file uploading will be disabled automatically after 11:59PM of the due date, so please turn in your work on time.

1. (10pt) Chapter 8, Exercise 1: (a), (c), (d), (e), (g).

Note that you may either specify the constraints as part of the CREATE TABLE statement, or add the constraints after the table is created using ALTER TABLE statements.

For +2 extra credit, read the MySQL documentation about AUTO_INCREMENT and use it for the OrderID column.

2. (10pt) Chapter 8, Exercise 2. For this exercise, you will need to use an ALTER TABLE statement to add the foreign key constraint. And unlike what the textbook says, this can be done with MySQL (version 5 or above).

3. (+5pt)  Chapter 8, Exercise 3.