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