Homework 0
CS422, Summer 2005


Due: Tuesday, June 28

Please put all the SQL statements in a script file and upload it using the online turnin server. Note that file uploading will be disabled automatically after 11:59PM of the due date, so please turn in your work on time.


[Reading]
[CREATE TABLE ] (10pt) Create the following three tables in the database with proper attribute types and constraints (primary key, foreign key, and not null).
[INSERT] (10pt) Use INSERT statements to populate the tables with some data so that each table has at least four records.

[SELECT] (20pt) Complete the following queries: