| August 18, 2005 | updated marks for a1, m, a2, a3, final and UNOFFICIAL final marks |
| August 18, 2005 |
updated marks for a1, m, a2, a3, final
marks for a1, m, a2, a3 Please report any innconsistencies by August 19 2PM |
| August 6, 2005 |
Office hour Friday August 12, 2-3pm, H420
Final: - material to cover: E/R, Relational algebra, Relational calculus, SQL (including recursive SQL), assertions, triggers, datalog, functional dependencies, multivalued dependencies, BCNF, 3NF, transactions. - aids allowed a regular double sided sheet of paper with definitions, notations, etc |
| July 25, 2005 |
DB2 resources
A sample make file for DB2 on fissure |
| July 22, 2005 |
ERRATA A3: in Part 3, Database Design, problem 3.1, "Consider relation
R(A, B, C, D, E, F, G)" should read "Consider relation R(A, B, C, D, E, F,
G, H)"
The database schema was updated, the check constraint in the subProject table has been eliminated. |
| July 14, 2005 | Current marks are available here . Search using the last 3 digits of you student number. Please report any discrepancies. |
| July 2, 2005 | Today, office hours from 5-6 pm |
| July 2, 2005 |
The database cscc43 was started and you can connect to it.
In order to run DB2, execute first the command source /primula/cscdb2/sqllib/db2cshrc Type db2 at the command prompt in order to launch DB2. Information about DB2 |
| June 28, 2005 | The office hours today, June 28 are cancelled |
| June 19, 2005 |
Complete version of Lecture 3 notes posted
As announced in the last lecture, Relational calculus is also part of the material for the midterm. Check the solutions for A1 regularly for updates. |
| June 15, 2005 |
Assignment 2 is posted.
Midterm: - in class, on June 21, from 7-8 PM - material to cover: E/R, Relational algebra, SQL (no checks, assertions or triggers). - aids allowed: a A4 (double sided) sheet of paper with definitions, notations, etc |
| June 12, 2005 | Typos were corrected in lecture 3 notes (Relational Calculus). The updated notes can be downloaded from the lecture notes page, under Lecture 3 |
| May 24, 2005 | The posting date for Assignment 1 is May 31st |