1 reply to this topic

[Interwebz]

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.

[WingedPanther]

I think you're looking at it from the wrong direction. Start with the PHP, what logic are you going to use to determine if there's a teacher to give a substitute lesson? What logic are you going to use to determine if there's a teacher to watch the students?

Start with what you want to do, then move backwards to ensure the data is present.