• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

A nice 'little' problem

 
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 156
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
This is at least in part a data modelling problem, not a Java problem... but java ranch doesn't have a general database forum...
You say you want to double-book a room, but later you say you have lectures and so forth that you don't want double-booked. Do you mean you've got some rooms which are lecture halls (no double-booking) and some which are labs (double-booking allowed)?
Anyway, the simplest thing that comes to mind is to track, for each room, how many computers it has, and to have each reservation track how many computer it needs.
 
reply
    Bookmark Topic Watch Topic
  • New Topic