Guide to Turning in Final Results for Assignment 4

First, download the FinalData2006.zip file, decompress the file, and then perform the following instructions.

Instructions for Final Test Case 1

1. Reset the database to the initial status. The initial status means the status right after you loaded AllCities, AllHops, AllLegs, and Serves data into the database, and after you added any triggers, PSMs, views, and such to the database, but before you routed any packages or altered any legs. This may simply involve deleting any packages from your database and resetting all of the total weights of packages currently booked on legs to 0, or it may be more complicated depending on your database.

2. Insert the following three commands at the beginning of the input1.Turnin file, which is given in the FinalData.zip file. This set of commands is just for turning any output off.

q

3

2

3. Execute your program as follows.

java YourProgram < input1.Turnin

4. Execute your program as follows.

java YourProgram < fqset2006_1.txt > yourresult1.txt

Instructions for Final Test Case 2

1. Again, reset the database to the initial status.

2. Insert the following three commands at the beginning of the input2.Turnin file, which is given previously.

q

3

2

3. Execute your program as follows.

java YourProgram < input2.Turnin

4. Execute your program as follows.

java YourProgram < fqset2006_2.txt > yourresult2.txt

Instructions for Final Test Case 3

1. Again, reset the database to the initial status.

2. Insert the following three commands at the beginning of the input3.Turnin file, which is given previously.

q

3

2

3. Execute your program as follows.

java YourProgram < input3.Turnin

4. Execute your program as follows.

java YourProgram < fqset2006_3.txt > yourresult3.txt

What you should turn in

1. Print out a hard copy of the three results (yourresult1.txt, yourresult2.txt, and yourresult3.txt) of running your program.

2. Print out your Java code.

3. Print out your table creating code. If you used triggers and views, print them out as well.

4. If you used Oracle PSMs, print them out.

5. File all the papers, write the names of members in your group on the top of the first page, and submit them.