Assignments

This webpage will contain copies of the handouts and announcements and hints for each assignment.

Please review the following policies:

Working in Teams

The assignments will be prepared in teams of two.

Submission Deadlines

Section Due in class: Time and Date
Monday Must be handed-in by the first five minutes of class the week that it is due, either in the Monday or in the Tuesday lecture.
Tuesday Must be handed-in by the first five minutes of class (in the Tuesday lecture) the week that it is due.
Wednesday Must be handed-in by the first five minutes of class (in the Wednesday lecture) the week that it is due.

Submission rules

  1. All assignments must be submitted electronically.
  2. Assignments that are "on-time" must be handed-in in class by the date and time that they are due.
  3. Assignments not handed-in within the first five minutes of lecture are considered late, and will not be accepted later in class.
  4. Late assignments must be emailed to your professor. 25% (absolute value) will be deducted for every day the assignment is late — to a maximum of two days.
  5. Assignments may not be submitted later than the last day of classes.

Writing Tips

Here are some writing tips that may help you improve the quality of your assignments.

Remarks

If you feel that a mistake was made on your assignment or exam mark:

  • You must fill out a remark request form, attach it to your assignment or exam, and submit it to your instructor.
    Note: the entire assignment will be remarked, so it is possible that your mark will actually go down.
  • Remark requests will only be accepted up to one week from the date that the assignment or exam is handed back to the class. Requests submitted later than one week will not be considered. Requests may be turned-in in class or to the instructor's office.
  • If you request a remarking and your reasoning is frivolous or not cogent, you will receive a 0 for the question (or -20% if the question value if the mark was already 0).
Assignments
# Dist. Date

Due Date

Description Supplementary Material Solution & Marking Scheme Value
1 Friday, Jan. 11
  • St. George: Tues, Jan. 29, 6:15 p.m.
  • UTSC:
    Wed Jan. 30, 7:15 p.m.
Relational Model,
Relational Algebra
Handout, and required Cover Page , FAQ and Clarifications
  15%
2 Friday, Jan. 25
  • St. George: Tues, Feb. 12, 6:15 p.m.
  • UTSC:
    Wed Feb. 13, 7:15 p.m.
SQL Handout (updated Feb 4)
and required DDL for schema creation , and the Cover Page ,FAQ and Clarifications
  10%
3 Thursday, Feb. 14
  • St. George: Tues, Mar. 4, 6:15 p.m.
  • UTSC:
    Wed, Mar. 5, 7:15 p.m.
Embedded SQL Handout, Assignment3.ddl and required Cover Page , FAQ and Clarifications
Marking Scripts 10%
4 Friday, Mar. 7
  • St. George: Tues, Mar. 25, 6:15 p.m.
  • UTSC:
    Wed, Mar. 26, 7:15 p.m.

Database design Handout, and required Cover Page , FAQ and Clarifications

 

15%