Interwebz Posted February 2, 2009 Share Posted February 2, 2009 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. Quote Link to comment https://forums.phpfreaks.com/topic/143456-database-model-help-wanted/ Share on other sites More sharing options...
gevans Posted February 2, 2009 Share Posted February 2, 2009 That should be all you need, teacher name and a unique id for each teacher (more details if needed). classses name of class and a unique id for each (more details if needed). schedule id of the teacher, id of the class, unique id, start time, finish time (more details if needed). Quote Link to comment https://forums.phpfreaks.com/topic/143456-database-model-help-wanted/#findComment-752537 Share on other sites More sharing options...
RichardRotterdam Posted February 2, 2009 Share Posted February 2, 2009 you could add a table absent to keep track of when a teacher is sick Quote Link to comment https://forums.phpfreaks.com/topic/143456-database-model-help-wanted/#findComment-752560 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.