A Gentle Introduction to

SQL


Pick an engine:

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.

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

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.

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

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