Hello,
We've been given an assignment for school to write a program in PHP with the help of a MySQL DB. We would like to hear how you would approach this.
The use of this program is to check if a teacher is absent. If a teacher is absent the program should be able to check if there's a teacher to give substitution lesson. If there isn't a substitute available, the program should check for a teacher who's able to keep an eye on the students.
We would like to know what DB-model you would use to realise.
The DB already contains this data:
- Data teachers
- Data Classes
- Course Schedule
Thanks in advance.