CSC343H: Assignments

Overview

We will post the assignment handouts here as they become available.

Assignment Topic (tentative) Weight Materials
Assignment 1 Relational Algebra 10% Handout
Assignment 2 Interactive and Embedded SQL 10% Handout, A2.ddl, JDBCExample.java
Automarker Notes: Test DB, Automarker Report
Assignment 3 XQuery, and Design and Normalization 10% Handout
Data.txt ("Innes" typo corrected 25 Nov)
years.dtd
histogram.dtd (Bar made an EMPTY element 27 Nov)
availability.dtd
(right click and "save as" to save the dtd files)
"Capture" script runall.sh
Here is the XQuery Tutorial

Late Policy

Make sure you are familiar with the the grace days and the lateness policy from the course information sheet. Note that apart from grace days, late assignments will receive a mark of 0, so please don't wait until the last minute!

Other Important Assignment Policies

Please review the other Assignment Policies set out in the course information sheet.

Assignment submission

All assignments will be submitted electronically, using the MarkUs system. Log in to it using your cdf login and password. When working in a pair, only one person should submit the assignment.

Declaring a partnership

For all of your assignments (although not your Gradiance exercises) you may work either alone or in a pair. You may choose any student, in either section of the course, as your partner. You may partner with the same student repeatedly, or change partners during the term -- it's all up to you. For each assignment, if you choose to work with a partner, you will need to declare your partnership on MarkUs.

To declare your partnership, one of you needs to invite the other to be a partner, and then they need to accept the invitation. To invite a partner, navigate to the appropriate MarkUs page for that assignment, find "Group Information", and click on "Invite". You will be prompted for the other student's cdf user name; enter it. To accept an invitation, find "Group Information" on the Assignment 1 page, find the invitation listed there, and click on "Join".

Although only one partner should submit the assignment, because you declared your partnership, we will know that both of you should get credit for the work -- no matter which of you submits it.

Submitting your work

To submit your work, navigate to the MarkUs page for the particular assignment, then click on the "Submissions" tab near the top. Click "Add a New File" and either type a file name or use the "Browse" button to choose one. Then click "Submit". You can submit a new version of a file later (before the deadline, of course); look in the "Replace" column.

Once you have submitted, click on the file's name to check that you submitted the correct version; We cannot accept any files after the due date, even if you have not modified them since the due date. Remember that spelling of filenames, including case, counts. If your file is not named correctly, your code will receive zero for correctness.

Working successfully in a pair

If you are working with a partner, make sure that you are actually working together. Your goal should be for the two of you to help each other learn the material and to avoid getting stuck with frustrating errors. If you split up the assignment and work separately, you are not getting practice on all aspects of the assignment.

Sometimes a student who is working with a partner drops the course in the middle of an assignment. If this happens, the other partner is still responsible for completing the assignment on time. If he or she has been actively engaged in the entire assignment, this should not be a problem; the assignments are designed so that an individual student can complete them. However, if the remaining partner has not been actively involved or does not have copies of all of the work, they will have serious difficulty completing the assignment. Make sure you don't find yourself in this situation: Be active in all parts of the assignment, and make sure that at the end of each meeting, both partners have a copy of all of the work.