1. [25] Create the tables. Submit your SQL scripts of CREATE TABLE commands. Enforce key and referential integrity constraints and any other constraints you have (e.g. unique, not null, check etc.).

2. [15] Insert into each table 4 records. Submit your INSERT commands and the final result of running "select * from YOUR_TABLE" for each of your tables (hint: you can cut and paste to a WORD document named as YOUR_LOGIN_prj3.doc  as a submission for example). You can insert 10 records for one or two tables to look at more interesting query results.

3. [20] Update a record in one table.  Update potentially several records at once using subqueries.

4. [40] Query your database. Submit the SQL scripts of five queries into the tables together with their running results on SQL server or Oracle. At least one query includes join operation; one has subquery in it; one has group by and having in it; one has set operation (union , intersect or except) in it.