Assignment 4, Fall 2011
=======================

Create tables, primary keys, and foreign keys in Oracle,
for your Airline Reservation schema, then populate the
tables with a reasonably sufficient number of rows
(enough to adequately test with in the future).

You may use your Access version of the tables as a starting point,
but you may also make improvements to your tables (naming, field
lengths, etc) as you wish.

ALL TABLE NAMES MUST BE BETWEEN 4 AND 6 CHARACTERS LONG.
ALL COLUMN NAMES MUST BE PREFIXED WITH THE TABLE NAME.
USE APPROPRIATE AND CONSISTENT ABBREVIATIONS, DATA TYPES, ETC.

Remember, you can look at the files provided in assignment 3
as examples of the syntax required for the sqlplus and sqlldr scripts.


Use sqlplus script(s) and sqlldr script(s) to populate your tables.
Use these in any combination, as long as you use at least one example
of sqlplus and at least one example of sqlldr.


After all creation and population scripts are successfully completed,
run an export (exp) to create a .dmp file of the export of your
schema (as well as a .log file of the screen’s output messages during
the export).


Zip and put into BlackBoard digital drop box as Assignment 4:

  All .sql scripts for sqlplus that you created
                     AND
  All .ctl control files for sqlldr that you created
                     AND
  Any external data file(s) for sqlldr that you created (if any)
                     AND
  All .lst files produced from spooling within the sqlplus scripts
                     AND
  All .log files produced by the sqlldr script(s) and schema export
                     AND
  The .dmp file from the schema export