Timetable database

Warning - you may only use Oracle or the ceres Engine for this database.

ER diagram for the timetable database:Graduated questions

The timetable database contains the following tables:

event
id module kind dow tod duration room
co12004.L01co12004LWednesday11:001cr.SMH
co12004.L02co12004LMonday17:001cr.B13
co12004.T01co12004TMonday11:002co.G78+G82
co12004.T02co12004TTuesday15:002co.B7
co12004.T03co12004TTuesday13:002co.G78+G82
... Result truncated.
student
id name sze parent
co1.BAeBAe15
co1.COComputing 1st Year150
co1.CO.aComputing 1st Year a20co1.CO
co1.CO.cComputing 1st Year c20co1.CO
co1.CO.dComputing 1st Year d20co1.CO
... Result truncated.
attend
student event
co1.BAeco12004.L01
co1.COco12004.L01
co1.ISco12004.L01
co1.SE.ptco12004.L02
co1.CO.aco12004.T01
... Result truncated.
teaches
staff event
co.AMnco12004.L01
co.RKco12004.L01
co.SRMco12004.L01
co.RKco12004.L02
co.SRMco12004.L02
... Result truncated.
staff
id name
co.ACgCumming, Andrew
co.ACrCrerar, Dr Alison
co.AFAArmitage, Dr Alistair
... Result truncated.
module
id name
co12001Rapid Application Development
co12002Software Development 1A
co12003Professional Skills
co12004Applications Workshop
... Result truncated.
room
id name capacity parent
co.117+11832
co.11716co.117+118
co.11816co.117+118
co.B740
... result truncated
week
id wkstart
0102/10/00
0209/10/00
0316/10/00
...Result truncated
occurs
event week
co12004.L011
co12004.L012
co12004.L013
co12004.L014
co12004.L015
... Result truncated.