| August 13, 2005 |
updated a1, t1, a2, t2, a3, t3 term marks
The next posting will include the final grades for this course |
| August 10, 2005 |
Office Hours: Monday August 15, 4 - 5pm, SF4306E
a1, t1, a2, t2, t3 marks |
| August 9, 2005 | current term marks |
| August 8, 2005 | Office hours Tuesday 11am - 12:30pm SF4306E |
| August 7, 2005 |
Sample solutions for Test 1
Sample solutions for Test 2 Office hours Monday 3 - 5pm SF4306E |
| August 6, 2005 |
Test 3:
- time & place: 1:00-3:00PM, in class - material: Relational Algebra, Relational Calculus, SQL queries(includes recursive queries), constraints, triggers, Datalog, functional dependencies, multivalued dependencies, database design -BCNF, 3NF-, transactions. You can bring a double sided, regular sheet of paper with definitions, notations, etc. There will be no tutorial. |
| July 25, 2005 |
A3 due date is August 5, 5pm
DB2 resources |
| July 23, 2005 | Term marks are posted here |
| 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)" |
| July 17, 2005 | There will be additional ofice hours on Monday from 3-4 pm in SF4302C |
| July 14, 2005 |
Test 2:
- time & place: 1:10-2:30PM, in class - material: SQL queries(includes recursive queries), constraints, triggers, Datalog. You can bring a double sided, regular sheet of paper with definitions, notations, etc. There will be a 1-hour lecture from 12-1pm and a 30-minute tutorial from 2:30-3pm. |
| July 12, 2005 | Today's ofice hours cancelled. |
| July 11, 2005 | A2 EXTENSION: the deadline for A2 is now Monday, July 18, 5pm |
| July 6, 2005 | Partial marks are posted here
. Search after the last 3 digits of your student number.
DB2 command options can be found here You are allowed to bring to every test a regular sheet of paper(double sided) containing definitions, notations, examples, etc. |
| June 20, 2005 | Assignment 2 is posted |
| June 20, 2005 | Improved version of A1 solutions posted. Check the solutions regularly for improvements/corrections |
| June 19, 2005 |
Complete version of Lecture 3 notes posted Office hours on Monday, June 20 5-7PM SF4302C. No office hours on Tuesday, June 21 |
| June 17, 2005 | Test 1:
- time & place: 1-2PM, in class - material: Relational Algebra, Relational Calculus There will be no tutorial. I will lecture from 12-1 and 2-3. |
| June 12, 2005 | Typos on lecture 3 notes (Relational Calculus) were corrected. An updated version can be downloaded from the lecture notes page, under Lecture 3 |
| June 7, 2005 | The notes for Lecture 1 are on shoart loan at the Engineering and Computer Science Library |
| June 5, 2005 | ERRATA: in Assignment1, Employee(eID, deptID, eName, city, salary, age) should read Employee(eID, eName, city, salary, age) and a new relation and two inclusion dependencies should be considered: WorksIn(eID, deptID), WorksIn[eid] Í Employee[eid], WorksIn[deptID] Í Department[deptID]. These changes are for the day section ONLY |
| May 30, 2005 | Assignment 1 is posted |
| May 24, 2005 | office hours from 11-12 are cancelled |