I would like to know how to handle clashes time tables.
Suppose TeacherA has a class on Sunday from 0700 to 0740 in Timetable1.
How does the Timetable Admins know that TeacherA is available or not for the same time on Sunday?
This is how our data looks.
Department: English(TeacherA, TeacherB), Matths(TeacherC), Science(TeacherA, TeacherD), etc
Course: English for Year 1, English for Year 2, Maths for Year 1, etc
Class: ENG-1A, ENG-1B, ENG-2A, MATH-1A, etc
To make it more clear;
I believe when I enroll TeacherA to ENG-1A, i shouldnt be able to enroll the same teacher for ENG-1B for the same period same day.
Or how do i know im making a clash? Or what is the proper way of enrolling without clashes?
I hope this makes sense.