逼我！都出来做题！ - 编程论坛

#2

zuojunjie2008-09-26 15:06

Easy Question
1. Give the name of the room in which the event co42010.L01 takes place.
2. For each event in module co72010 show the day, the time and the place.
3. List the names of the staff who teach on module co72010.
4. Give a list of the staff and module number associated with events using room cr.132 on Wednesday, include the time each event starts.
5. Give a list of the student groups which take modules with the word 'Database' in the name.

#3

zuojunjie2008-09-26 15:08

Medium Questions
6. Show the 'size' of each of the co72010 events. Size is the total number of students attending each event.
7. For each post-graduate module, show the size of the teaching team. (post graduate modules start with the code co7).
8. Give the full name of those modules which include events taught for fewer than 10 weeks.
9. Identify those events which start at the same time as one of the co72010 lectures.
10. How many members of staff have contact time which is greater than the average?

#4

zuojunjie2008-09-26 15:09

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

#5

西风独自凉2008-09-26 15:21

視力不好﹐英文不行﹐路過