school attendance
Posted: Tue Apr 13, 2010 3:34 pm
Hello. I have a quick question. I am making a school database and I want to do an attendance form. I am a little bit confused of what is the best approach. Right now i did this.
One table (member) with member_id and student_name. One "attendance" table with attendance_id, attendance_date, student_id, type_attendace. Type_attendance means a code to differentiate if the person is late or on time.
Then in the php i will have a type of grid, that gives me in the left all the names of the student, and then to the right a box where i write the code. Is that the best approach to do this? thanks!
One table (member) with member_id and student_name. One "attendance" table with attendance_id, attendance_date, student_id, type_attendace. Type_attendance means a code to differentiate if the person is late or on time.
Then in the php i will have a type of grid, that gives me in the left all the names of the student, and then to the right a box where i write the code. Is that the best approach to do this? thanks!