On Tue, May 21, 2013 at 12:25 PM, Gary Jeurink <[email protected]>wrote:
> I am trying to develop a gymnastics school management system. I am building > the classes table and I need to build it so I can look at when each class > starts and which day it is on so I that can allocate specific gym space > per > class at various times. I can't help but think of the local community school program that offers classes in the evening and weekends. Nearly every class is listed as "9 weeks on Wednesday from 6 PM tp 7:30 PM, except school vacation weeks," or "No class on Memorial Day" or Yom Kipur or because that's the night of the senior prom. Some meet each week with a make-up class on Saturday, or a lab the first Thurday of each month. We write database applications because the rules are simple, but the exceptions are hard. I would be more inclined to set up the classes with individual records for each meeting. Each record could have a date and a time-start and time-end. Time stores pretty well as a 4-digit integer as long as you don't try to do math on it :) These records would be child-records of the class record and parent-records of the attendance records. This way, you could centralize the creation of all the individual records at the point where the class is created, and enter any exceptions at that point. The rest of the application only needs to find records on the date and time-range it is concerned with. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACW6n4vrxHipmYB1Yo_Ap9_BzqBpmjD9=2hagsm-a6syjf3...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
