Jump to content

Give me some vision..


r1nk
 Share

Go to solution Solved by mac_gyver,

Recommended Posts

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?

 

Link to comment
Share on other sites

  • Solution

you are still showing a separate table for each different type of user and you have usernames stored in related tables, rather than using the user's id.

 

you were told two or three threads ago not to have separate tables for same meaning information (the users) and you have since gotten your login code to work with a 'type' field in your user table.

 

since you have posted old/out of date table definitions, you need to rework those before you can write any code to use that data.

 

 


 

anyway, to answer your question -

 

when a logged in lecturer navigates to the attendance page, you would use their user id to retrieve their list of subjects/classes. when they click on one of them, you would use the class id to retrieve the list of students in that class.

Link to comment
Share on other sites

This thread is more than a year old. Are you sure you have something important to add to it?

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.