CSCC43: Introduction to Databases
Summer 2009


Course Assessment

Assignments   |   Tests   |  Marks

Assignments

No. Handout Weight Posting Date Due Date Sampe Solution
1 Relational Algebra
10% May 11 May 31 Sol, Stats
2 SQL 10% June 1 June 21 Sol, Stats
3 XML 10% June 24 July 12
July 16
Sol, Stats
4 DB Design 10% July 13 Aug 5 Sol, Stats

Submission

All assignments must be electronically submitted by the specified deadline. As well - you must submit a paper copy within the first 10 minutes of class. If you plan to submit late (and take the applicable penalty), be sure to email your electronic copy to the professor. Otherwise, your assignment will probably not get marked.

The electronic submission must contain a file call group.txt which contain information about all members of your group and your submission directory; you can find a template of this file at here.

All assignments are submitted on starveling mathlab:

You may submit from the lab PCs or from home.The steps are very similar. Please note that not being able to submit from home is not an excuse for being late; if you're not sure how to do it (especially for the first assignment) the night before the assignment is due is probably not a good time to start. You have practiced submitting from the lab.

If you are going to try from home, you need two pieces of software, and an address to connect to (starveling's address). The software is listed below; here is the address: starveling.utsc.utoronto.ca mathlab.utsc.utoronto.ca

  1. Download PuTTY from here - the same application you used in the computer labs to log in to starveling.
  2. Download and install PSCP or PSFTP from this sight as well. These will allow you to save files on your home directory, from home.

To Submit

Ensure that your assignment files are on your home directory. Once you have placed your files on your home directory, you have to submit them into the proper submit directory. This step is the same for the labs and for home:

  1. Log in to starveling using PuTTY - use the same userid/password combination you use for the labs or the intranet.
  2. Use the cd dirname command on starveling to navigate to the directory dirname that has your files in it.
  3. Use the submit command to submit your assignment, as follows:
    submit -N An cscc43h F1 F2 F3
    submit -N An cscc43s09 F1 F2 F3
    Where n is your current assignment number (1 for A1, 2 for A2, etc.) and F1, F2, etc. are the files you created for the assignment.
Notes
  1. If you have more than one file to submit, you don't have to submit them all at the same time.
  2. You can always re-submit a file (or set of files) if you think you have a better version by using:
    submit -N An -f cscc43h Whateveryoufilename
    The -f after the assignment number will force the submit of the new file(s). This will delete the existing version of the file(s).
  3. Important: group submits: starveling does not know who your partner is, so please do not split your submits - only one of a group members needs to submit; whoever it is, they must submit everything.
  4. You can check your submits with the command:
    listsub cscc43h An
  5. For more information about the submission command - check the man page (man submit).

Computing Labs

UTSC Computing facilities are available to students in the Bladen Building, 4 th floor, and in the Informatics Commons in the UTSC Library. Four labs, BV-473, BV-490, BV-494, and BV-498, are designated for 24-hour use. Printing, including wireless printing, is available in all computing locations; your T-card is used to pay for and release print jobs from print stations. CopyKats has additional printing services.

[Top]


Tests

Test Weight Date Sample Solution
Midterm 20% June 22 (in class)
Final exam 40% Please check UTSC Final Exam Schedule

You can find some past final exams here.

[Top]


Marks

Click here to check your marks on Blackboard.

[Top]