Hello wonderful people!
Question: How do i approach the following relationships: Teacher <-> Grade <-> Subject
Multiple teachers can have multiple grades of students, with each different or same subjects.
Example: Mr. Teacher has the 7th grade in math and physics and the 8th grade in physics and latin. The 7th grade does not have latin at all, and they have math with a different teacher.
Dream scenario would be something like "cascading subchoices". I create a new entry in the "teacher" table, add the 7th. and 8th. grades, which then gives me the available subjects within each grade to choose from.
Thank you for your expertise, i appreciate it a lot!
