I'm trying to do a produce a Computerised Room timetabling system for my IT
department at College using
Java and
JDBC. So far I've managed to add/delete/edit records for information on Rooms, Staff Members and Courses.
I'm now trying to add lessons for courses, here is where my problem lies.
The IT department want the possibility that some rooms within the department to be doubled booked, as a class generally contains about 30
students and some rooms have the capacity of 100 computers. So a room
could easily contain 2/3 classes at the same time. How this can be
acheived using Java? Making sure that staff members and times for lessons
arent also doubled booked aswell, e.g. a lessons time (time it starts and
finish) doesnt overlap with another lesson.
Hope this is clear (its probably not), Any help with this would be most
appreciated.