Im now making a simple project called student attendance.. I've just managed the register/login part..
Right now, these are the tables that i created so far..
http://i272.photobucket.com/albums/jj178/r1nk_2008/1_zpsf1765f1c.png
http://i272.photobucket.com/albums/jj178/r1nk_2008/2_zpsa1a1310a.png
http://i272.photobucket.com/albums/jj178/r1nk_2008/3_zps092b7ff1.png
http://i272.photobucket.com/albums/jj178/r1nk_2008/4_zps1fffbc49.png
What i need right now is some advice on how :-
The lecturer can select the course_id that have been assigned and then list of subject he/she teach will appear.. Based on what subject he/she clicked, an attendance table appear with list of students in that class and week 1- week XX (checkbox for attendance)..
Do i need to assign some primary and foreign key in my tables or adding some more necessary tables?