Database Design question for scheduling app

Any advice/code samples/pointers on how to set up a SQL Server 7 database for a scheduling app:

Here is the scenario: We need to set up a db to schedule class times using audioconference bridge. We have isolated 6 blocks of regular time each day into which we can schedule up to nine class sections at a time for simultaneous use. So the problem is not one of overlapping time, but of too many instances of overlap in any time period.

I would like the system to be flexible enough to easily accomodate changes in the time blocks that are available (for instance, if right now we had six two hour blocks starting at 8,10,12, etc, we might in the future have five blocks starting at different start times with different lengths, etc).

Classes can be anywhere from 1-3 days per week, though they will always be at the same time each day.

I have no idea how to approach this!

c

--
Chris Lott <chris.lott_at_uaf.edu>