Results 1 to 1 of 1
Thread: Student Timetable System
Nov 16, 2008, 17:10 #1
- Join Date
- Nov 2008
- 0 Post(s)
- 0 Thread(s)
Student Timetable System
I am developing a standard Student timetable system to learn php /mysql in depth. I've few questions if somebody can assist.
Background info: Each course can have multiple sessions identified or tracked by 'room' , 'hour', 'day'. Students can enroll in 1 or many course.
Here are the standard requirements:
1) Students and staffs able to login, view and print their timetable
2) Staff are able to see which students courses clashes.
2) Admin can do regular things like edit, delete etc
1) Is my ERD correct
2) Should staff,staff, admin be in 1 table (users table) distinct by user_permission
3) Stuck on this -> How to get the data from the mysql table and display it.
Rows should have time in interval of 1 hour , e.g. 9-10, 10-11, 11-12 etc
Columns should have Day name e.g Mon, Tue, Wed