1. Rebuild the new table structure that contains at least 4 tables (use Notepad). 

2. Use tables to show what the NEW schema looks like (either type the schema out in word or a text editor or show the print of the "desc tablename" of all tables.)

3. (A) Create a sequence and use it to enter data into at least 1 table. Show the command and output.

3. (B) Insert data into all tables / AND / (C) "select" all records from all tables (this shows successful completion)

4. Develop 7 separate queries (labeled query A through query I )

A. 1 query may use only 1 table

B. 2 queries need to use information from multiple tables

C. 1 query needs to search on a "Null"

D. Sort 1 query output appropriately (order by)

E. Use calculations (I'm thinking numerical) in 1 query (format output like $999.99)

F. Determine "how many" in at least 1 query

How many entries are in Track table

G. Create 1 nested query

5.  Create a save point (show deleted and restored data) show before, command, and after for credit