Quick Ref.
Functions
date
number
string
Data Types
date
number
string

Timetable database: hard questions

11. co.CHt is to be given all the teaching that co.ACg currently does. Identify those events which will clash.

Results
12. Produce a table showing the utilisation rate and the occupancy level for all rooms with a capacity more than 60.

Results
13. A one hour staff meeting is to be held between 09:00 and 17:00. Events which clash are to be cancelled. Identify the hour which will result in the least disruption.

Results
14. Find all clashes - include the events which clash and the staff, student or rooms that they have in common.

Results
15. Produce a timetable for a group of full time students for week 1

Results