I have set myself a project of creating a school management system which is to allow for a parent easier access to a 'profile' of their child, showing their progress in school, But i am having a few issues on the design of the database.
Number 1: Grades.
I am not sure how to go about storing each pupil's grades. I was considering having a table which would hold a row for each different subject, and a teacher would insert the grades of only the subjects which the pupil takes, and holding a studentid row which would connect it to the student. Should i proceed with this idea, or is there a better way to do this ?
In the first 5 years in the school there would be numerous subjects for the students, but for the college years, there would be considerably less.
Number 2: Timetable.
The 'base' timetable would be 5 subjects a day, so i was considering a hard-coded table of mon_1, mon_2, mon_3 and so on, giving me 25 rows in the table for the timetables, and for the college years, putting an option of 'Free' for those periods. Should this be the approach I take, or again, is there a better option?
View Complete Post