January 4th, 2013, 07:24 PM
Thank you again for helping me. I am still a bit unclear on one thing:
students -> student_class -> class -> class_timings
class (class_id, teacher_id, class_desc)
class_timing (class_id, day, time)
Now how do I "schedule" each class in the database so that i have something for example:
Class 1 - Monday 9th October
Class 1 - Monday 16th October
I was thinking to simply have another table:
schedule (class_id, day, time)
then the application can make sure that for example: if a class only happens on Monday, the teacher/student cannot schedule that class for a Tuesday?
Another few questions:
1. Do i have one table for student and another for teacher? or should I have one table and have an extra column called "type"
2. Do i store the timings as day/times or day/periods (as is common with schools they have periods/lessons)
http://www.databaseanswers.org/data_models/student_rosters/index.htm seems to have two tables and using periods so I wondered.