Computer Laboratory

Course pages 2015–16


Last change: Wed Mar 9 11:49:44 GMT 2016

Study/Supervision/Revision Guide

Never forget to ask What problem am I solving? Exercise: List all of the mistakes made in this article:

Lecture Slides:

A few SQL examples that may clarify the relational implementation of many-to-many and one-to-many relationships (from an ER model).

Relational division example : relational_division.sql. An interesting paper on relational division :

Some open source database systems :

  • HyperSQL :
    • To use from Java code (as used in Further Java) : Unzip the archive file, change to extracted directory, then launch a database GUI with java -cp {YOURPATH}hsqldb.jar org.hsqldb.util.DatabaseManagerSwing.
    • To use the read-execute-print loop use sqltool.jar, java -jar {YOURPATH}sqltool.jar. You may have to set up a sqltool.rc file in your home directory as documented at
  • Postgres :
  • MySQL :
  • SQLite :

Primary sources:

iMDB data:

Of interest (reading for the fun of it):

Never forget to ask What problem am I solving?