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.

We've been given an assignment for school to write a program in PHP with the help of a MySQL DB

We don't solve assignments.
Show us your approaches to solve this problem!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.