cscC43/csc343 Winter 2008

Assignments

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

Please review the following policies:

The assignments will be prepared in teams of two or three.

All assignments must be submitted electronically.
Late assignments: each student is allowed a 24-hour grace period to be used on one of the three assignments. All students in a team that takes advantage of the grace period will be considered to have used their grace days. A team can submit a late assignment only if none of the team members has used his or her grace day.

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

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.
Requests may be turned-in in class or to the instructor's office.

Assignments
#	Distribution Date	Due Date	Description	Supplementary Material	Solution & Marking Scheme	Value
1	January 15	~~February 5~~ New due date: February 12	ER Model, Relational Model, Functional Dependencies	Handout, FAQ and Clarifications	Selected solutions	10%
2	February 17	March 10	Relational Algebra	Handout, FAQ and Clarifications	Selected solutions	15%
3	March 16	April 3	SQL	Handout, Table definitions, CORRECTION: in methods query1 and query3, parameter departmentCode is of type String instead of int. In method insertStudent , parameter departmentName should read departmentCode. FAQ and Clarifications	Here is the database used to mark the third assignment.	15%