COMP9315 Final Exam

The University of New South Wales COMP9315 DBMS Implementation 22T1 Final Exam Instructions

DBMS Implementation

Before continuing on with reading this, please read and acknowledge the following:

I acknowledge that all of the work I submit for this exam will be completed by me without assistance from anyone else.

Warning: We will be running plagiarism-checking on your submissions.
Plagiarism, especially in exams, will be prosecuted as Student Misconduct.

This document has five sections:

• Setting up your on-screen workspace
• A note on downloading
• Reading the exam paper
• Setting up your working directory
• Submitting your answers

You might want to keep this document open in a browser tab in case you need to refer to it.

You can work on the exam either on your laptop/workstation at home or by logging in to your CSE asccount on one of the CSE servers. However you choose to do it, you should

• First make a new directory/folder called e.g. exam

• Then make this your current directory and do all your work there

Setting up your on-screen workspace

We suggest that you open a browser with the following tabs:

COMP9315 Home Page

To keep track of any notices related to the exam; refresh this page every so often.

This Instruction Page

Just in case you need to check it again..

The Final Exam Submission page

If you plan to submit your answers through Webcms3.

The Final Exam Paper

To read the questions and instructions.

Also, open a terminal window for testing your programs. If you use an editor like vim, you can also use this window for editing. And open a window where you edit your answers.

You should also have a mail reader open to receive any updates on the exam (which will also be posted on the Webcms3 Notices), or to ask for clarification on any question (email cs9315@cse.unsw.edu.au).

Note on Downloading

If you click on the links to exam-*.zip below, your browser will most likely put them in your downloads folder, and may even unzip them for you. Check the downloads folder and move the relevant directory (work or paper) into your exam directory. If the downloads folder contains the zip file, then move that to your exam directory.

You can generally force browsers to downlod the exam-*.zip file without unzip'ing it by using a right mouse-click on the link. Once you have the zip file in your exam directory, you can run the unzip command manually.

Reading the exam paper

If you want to put the exam paper on your laptop at home ...

• Unzip the file https://www.cse.unsw.edu.au/~cs9315/23T1/exam/22t1/exam-paper.zip

• This will create a new directory called paper under your current directory

• Start your web browser and access the paper via the File > Open File menu item

If you want to view the exam paper via the CSE web server ...

• Start your web browser

• Open this link to the paper on the CSE servers

Setting up your working directory

If you want to work on your laptop/workstation at home ...

• You will need to have gcc and make installed on your machine

• Unzip the file https://www.cse.unsw.edu.au/~cs9315/23T1/exam/22t1/exam-work.zip

If you want to work on the CSE servers ...

• Login to a CSE server either via putty or VLab

• Unzip the file /web/cs9315/23T1/exam/22t1/exam-work.zip

After doing either of the above, you will have a new directory called work. In this directory you will find:

q1/

A directory containing all of the files for completing the 1st programming question, including a run_tests.sh script

q2/

A directory containing all of the files for completing the 2nd programming question, including a run_tests.sh script

q3/

A directory containing all of the files for completing the 3rd programming question, including a run_tests.sh script

q4.txt, ... q8.txt

Templates for answering the written questions. Edit these files using a text editor of your choosing, and submit the edited files.

Submitting your answers

You must submit all files containing your answers via give. You can give files either via Webcms3 or via the command-line. If you use the command line version of give the files will need to be loaded onto a CSE server (details below).

If you are working on your laptop/workstation at home ...

• You have two options: Webcms3 or command-line:

  Webcms3

  • go to the Submit Qx page under Final Exam

  • click on the Make Submssion tab, select the file, and click Submit

  command-line

  • use scp (or any other file copying mechanism) to put the file onto your CSE account

  • example:   scp q3.txt z1234567@cse.unsw.edu.au:q3.txt   (don't forget the :)

  • login to your CSE account (e.g. via ssh or putty) and run the give command as described at the bottom of the question

  • example:   give cs9315 exam_q7 q7.txt

If you are working on the CSE servers ...

• You can directly use give as described at the bottom of the question

• example:   give cs9315 exam_q4 q4.txt