CIS332 – Assignment #9

Write SQL scripts for the 10 problems in the Chapter 9 Hands-On Assignments section on page 287 of the textbook.

Name the scripts 09xx.sql where xx is the problem number. For example, the script for the 1^st problem would be 0901.sql.

Create a zip file named <your name>-09.zip that contains your SQL scripts.

Email the zip file with your scripts to my DMACC email address (rebullard@dmacc.edu).

This assignment is worth a total of 10 points (1 point for each problem) and is due by midnight on 4/13/09.

Note: Problems 4 & 10 should use “colA” and not “colB”.