Office hours: None, but arrangements can be made if you approach me after a lecture or by e-mail to hughdarwen@gmail.com
Updates made during 2009 presentation:
15 December 2009: Added solutions to
course work assignment 2009.
20 November 2009: Added solutions to
Worksheet 4 and exercises
in lecture 9.
02 November 2009: Revision to Lecture
9, Slide 19, and also the notes for
that slide.
30 October 2009: Added solutions to
Worksheet 3 and exercises
in lectures 4-6.
19 October 2009: Added solutions to
Worksheet 1 and exercises
in lectures 1-3. Also, corrected the error in the notes
for Lecture 4, Slide 10 (as mentioned in the lecture).
14 October 2009: Added exercise on user-defined types to Worksheet
#4.
13 October 2009: Minor corrections to Lecture
3, Slide 4, and also the notes for
that slide.
12 October 2009: Corrections to Lecture
2, Slides 14 and 15, to conform with Rel.
06 October 2009: Correction to Lecture
1, Slide 16.
05 October 2009: The errors in Hugh's
book mentioned on 03 September have all been corrected but three new ones
have come to light (see here). If you
find some more, do please
report them to me!
03 September 2009: Added link to Hugh's
book (a free download) based on his CS252 lectures. Also added an
errata.
We are using a new version of Rel. In case of any problems you may wish to study the Rel forum at http://shark.armchair.mb.ca/~dave/relforum/index.php, in the section named Report a Bug.
Updates made during 2008 presentation:
Watch this space!
| 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 |
Various people around the world are engaged in prototype or "proof of concept" projects connected with The Third Manifesto (TTM). A list of such projects is given on the projects page of the TTM web site. One such project is Rel, the implementation of Tutorial D that we use for exercises and coursework in CS252. Another is MighTyD, a 4th-year undergraduate project undertaken in 2005-6 by a team from this university and extended by a 3rd-year student in 2006-7. Ingres D is a recent and very welcome addition, involving making a well-known industrial DBMS that already "speaks" two languages acquire a third one (based heavily on Tutorial D).
Owners of the following projects have expressed interest in collaborating with students, especially students who have attended modules CS252 or CS253 on further enhancements to their projects:
Ingres D
Rel
SIRA_PRISE (its creator, Erwin Smout, has several suggestions, including
evaluation)
Duro
Muldis Rosetta
Dee
MighTyD (one original team member probably available for collaboration)
Further information on each one can be found at the aforementioned web page.
An additional opportunity exists, probably more appropriate for M.Sc. projects, in connection with Ingres. Ingres is an SQL implementation recently made available as open source by its present owners, Ingres Corporation. I am currently in discussion with contacts at this organisation who would like to see the existence of a TTM-conforming language interface as an alternative to SQL. (Ingres was originally developed in the 1970s with a language called Quel, claimed to be significantly "more relational" than SQL. The SQL interface was added later for obvious commercial reasons.)
I would offer to participate in the role of "customer" for any students undertaking projects inspired by The Third Manifesto.