Assignment 1

1. Chapter 6
   Create SQL queries given in questions 5-7.
   You will need to run the ch06dbinit.sql script for loading the necessary tables into the Oracle database. This is provided on the student CD-ROM that accompanies the text book. Look under the "/SQL/CH06/dataload" directory. Alternatively, you can download the script from here.
2. Chapter 7
   Create SQL queries given in questions 7, 8, 9, 10.
   You will need to run the ch07bdbinit.sql script for loading the necessary tables into the Oracle database. This is provided on the student CD-ROM that accompanies the text book. Look under the "/SQL/CH07/dataload" directory. Alternatively, you can download the script from here.