Last post Apr 11, 2011 03:16 AM by pranayesh
Feb 08, 2010 01:48 AM|grgrth|LINK
Hi i need to develop a page that displays results of students using their roll no as search parameter. I have no problem with that.
My issue is that i need to develop a form to store the invidual results of each students by their class teachers. i am not getting any ideas.
The fields im going to use are
Exam Name. Halyearly/Annul
Subjects. Subjects differ for each class
I dont want the class teachers to type the subject names while entering the marks for each student. How can i get the subject names of a class and store them and then create a form to insert marks for those subjects.
Please help. I am confused
Feb 08, 2010 04:26 AM|shawpnendu|LINK
You can start with below tables:
student(ID, roll,name,Dept(FK),....,EduYear)(Edu year means class like first year,secod year .. final year)//You also can maintain another master table for year.
So now if you enter a roll number(if PK) then you can easily identify the dept, edu year,subjects & corresponding marks.
Rollnumber then find frst dept & year, By using dept & year you will get list of subjjects.
Let me know if you can understand yet.
Apr 11, 2011 03:16 AM|pranayesh|LINK
yes you can add data of each student with class teacher , u can user a drop down for class teacher name and save class teacher id in
thanks to you .