Marking Assignment 2

Many of you want to know how the automarker assessed the performance of your program. Your TA (Dimitris Tsirogiannis) has made the programs and scripts available to you with the following instructions. Please keep in mind that the automarker was not relied on exclusively to determine your mark. The TAs were careful to look at every submission and manually determine if, when the automarker failed, you deserved partial marks for the work that you did.

Files that you will need

• A2_sol.sql : a sample solution for the sql part
• A2_inserts.sql : the insert statements to populate the relations
• A2.DDL : create table statements
• marking.sh : the automarker shell script
• TestAssignment2.java : the test file for the jdbc part

Instructions

The script takes the submission id as input (e.g. c1faye), goes inside the directory that has the same name as the submission id, then inside the subdirectory (A2 or A2-late) and runs the queries and the jdbc part.

Hence, in order to run properly, you must have the following directory hierarchy <submission id>/A2(or A2-late)/ (e.g. c1faye/A2/) in their home directory. The marking.sh must run from the home directory as well.

You may have to fidgit with the script to make it work in your directory for you. (e.g., You will have to go into the script and change userids where they exist to reflect your userid and database.)