|
Would be appreciate it if anyone can help with the following:
I am trying to create a database based system to handle the school reporting for the school that I work at during my week off.
I have managed to suss most of the structure but am stumbling on three parts.
================================================== ==============================
1 - school timetabling
================================================== ==============================
Each form has a time table (+ teacher, location)
each time table has 5 days
each day has 6 sessions
each session has subject, teacher, location
(form, subject, teachers & location tables sorted)
================================================== ==============================
2 - school points system
================================================== ==============================
Each student receives points for each of six session during each day
as well as points a memo needs to be added for each of the six sessions per day
there are five educational days per week
each week and each day the total points need storing
================================================== ==============================
3 - school attendance system
================================================== ==============================
for each year
52 weeks with 5 days a week
each day receives an attendance mark
(attendance mark table sorted)
-----------------------------------------------------
Thanks in advance
Lea
|
