I'm trying to store schedules for student's work schedules. I cannot
seem to come up with a good design of the data though. The biggested
problem is that the students can work any number of shifts in a given
day, so storing start and end times as two fields, or even multiple
sets as two fields is not really an option. Currently the day is
broken into 15 min increments and a series of 1's and 0's is scattered
through a 64 character string to indicate when they work. This is
horribly inefficent when trying to use the schedule to ...