I want to create a database to track the absences of teaching staff and allocate colleagues to cover their classes when they are off. As part of this I want to include the master timetable in the database. I am having difficulty with this. I don't know how to set up the classes so they they repeat, say every Tuesday at 11.00am from now until 31 May 2013. Can someone help me?
I am also planning the following tables in my database. I am looking for advice on whether this is sensible. Any advice gratefully received. I am new to this. I am working my way through the tutorials but I hope someone here can help!
Table 1 = Staff
Table 2 = Attendance/Absence
Table 3 = Classes
Any advice gratefully received.