Office hours: None, but arrangements can be made if you approach me after a lecture or by e-mail to hughdarwen@gmail.com
(click here to see the overall CS252 module and the schedule of lectures and seminars for the current presentation)
Updates made during 2011 presentation:
11 November 2011: Belatedly posted solutions to Worksheet
3, Worksheet 4, Exercises
in lectures 4-6, Exercises
in Lecture 9.
19 October 2011: Updated Lecture
7, Slide 20, to clarify its point. Please note that your printed
handouts do not reflect this change. Also, added the message below concerning Rel
version 1.06 beta.
13 October 2011: Added required semicolons to Lecture
4, Slide 14
13 October 2011: Posted solutions to Worksheet 1 and
solutions to Exercises in
Lectures 1, 2 and 3
02 October 2011: Revision of notes
for Lecture 1 (minor editorial fixes only)
In case of any problems with Rel you may wish to study the Rel forum, in the section named Report a Bug. I recently discovered a bug in version 1.06 beta, reported in the forum. If you are working with that version you may wish to replace it by 1.07 beta, in which the bug is fixed.
| Lecture handouts (PDF) | Slides (PPT) | Notes keyed to slides (PDF) |
| How to Handle Missing Information Without Using NULL | Slides | Notes |
| Temporal Data and The Relational Model | Slides | Notes |
| The Askew Wall (SQL and The Relational Model) | Slides | Notes |
| Additional Material | ||
| Hints regarding exam questions on Hugh's lectures | ||
| Exercises on Temporal Data | ||
| Past exam questions |