How to model timeslots?

From: <bamon_at_ocvaxc.cc.oberlin.edu>
Date: 28 Jul 93 09:07:01 EDT
Message-ID: <1993Jul28.090701.1_at_ocvaxc.cc.oberlin.edu>


How is everybody modelling time slots for storage in a database?

Specifically, I want to be able to store class meeting times and room assignment times. These are time slots or multiple time slots.

For example,

         Mondays 9:00-9:50a.m. and 1:00-2:00p.m.
  or     Tuesdays & Thursdays 10:00 - 10:50 a.m.
  or     Mondays & Wednesdays 2:00 - 2:50 p.m. and Fridays 9:00 - 9:50 a.m.

Obviously, if I can come up with a great way to model a single time slot, I can use multiple rows for multiple timeslots. I'm just looking for ideas. Everything I've come up with seems really clumsy.

Thanks in advance.


Jennifer R. Amon            PHONE: (216) 775-6987   
Houck Computing Center        FAX: (216) 775-8573    
Oberlin College          
Oberlin, OH 44074        INTERNET: bamon_at_ocvaxc.cc.oberlin.edu

_____________________________________________________________________
Received on Wed Jul 28 1993 - 15:07:01 CEST

Original text of this message