Matthew, you may want to investigate MRBS (Meeting Room Booking System). it handles such things for resource allocation. i dont know where the project location is, but google is your friend ....
"Matthew Crouch" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > this is a big question and i'm not trying to get you to do my modelling > for me, but if anyone has experience with this i'd appreciate being > pointed in the right direction: > How could one efficiently manage time slots in a dB? I mean for example > telling the dB that Mike can be somewhere at 6:15 or 6:30 but not 6:45, > and that Cynthia can be there at 6:15 or 7:00... > ...and so on > my instinct is to create a "timeslots" table, but it looks like it would > contain 35,040 records (one for each 15-minute period in the year). > egad! The alternative is to create timeslots a month at a time or > something, but the table would have to be reformulated every month. > > any thoughts? feel free to get philosophical about it. > > -M > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php