Homework | Weight | Due date |
---|---|---|
Assignment 1 | 8% | Wednesday, January 31 |
Assignment 2 | 8% | Wednesday, February 14 |
Assignment 3 | 8% | Wednesday, March 7 |
Assignment 4 | 8% | Wednesday, March 21 |
Assignment 5 | 8% | Wednesday, April 4 |
Announcements, clarifications, corrections and revisions to assignment specifications are posted to the Announcements page. Please read this page regularly.
The database D stores a set of ship records for all the ships that are already moored in the port.
Each ship record in D is represented by some pair (p,c), where p is the pier location of the ship, and c is the ship's present capacity.
During an INSERT, you are given a pointer x to a ship record (p,c) and your task is just to insert this new record into the database D.
Note that in this question you are NOT concerned about how a pier is assigned to a ship when it docks (this assignment is done by some procedure that is external to this database): As far as you are concerned, when a ship of capacity c docks, it already has a given pier number p (that you cannot change). So all you have to do for an INSERT is to enter the new ship record (p,c) into the database D.
The pier number of ship record is fixed and never changes (because a docked ship does not change pier).
Do not assume that there is a small number of pier locations, or of ship capacities (a ship capacity can be any real number).
Assignments will consist of a number of "pen-and-paper" questions (the "written" portion, whose solution involves no computer programming and can be handwritten or typed) and a number of "programming" questions (whose solution is entirely computer programming).
The written portion must be handed in using the cover sheet for assignments (Adobe PDF document) (PS). If you are working in a group (of at most two students), only submit one copy of your solutions and write both students' names on the cover sheet. All written portions must be submitted directly to the instructor by the beginning of class on the specified due date. Late assignments will not be accepted (including assignments submitted after the first 5 minutes of class) except in truly unusual circumstances. (See the policy on special consideration for how to request an individual extension for unusual circumstances).
The programming portion must be handed in electronically using the UTSC submit command. Hardcopies (such as computer printouts) will not be accepted, as your code will be executed to determine your mark. If you are working in a group (of at most two students), only submit one copy of your programming solutions and include both students' names in the file headers. Though your programming portion is due at the same time as the written portion, we will not collect the electronic submissions until Thursday at 5:30pm (so you may think of this as an automatic extension). It is your responsibility to ensure your programming solution is submitted on time, as we cannot automatically disable acceptance through submit at a predetermined time. Ensure your programs work correctly on the UTSC computer system; if they do not, you will not receive any credit.
Frequently solved problems:
|