Categories

See More
Popular Forum

MBA (4887) B.Tech (1769) Engineering (1486) Class 12 (1030) Study Abroad (1004) Computer Science and Engineering (988) Business Management Studies (865) BBA (846) Diploma (746) CAT (651) B.Com (648) B.Sc (643) JEE Mains (618) Mechanical Engineering (574) Exam (525) India (462) Career (452) All Time Q&A (439) Mass Communication (427) BCA (417) Science (384) Computers & IT (Non-Engg) (383) Medicine & Health Sciences (381) Hotel Management (373) Civil Engineering (353) MCA (349) Tuteehub Top Questions (348) Distance (340) Colleges in India (334)
See More

Exam Result Publishing mysql

Course Queries Competitions/Entrance Exams
Max. 2000 characters
Replies

usr_profile.png
Charles Kyobe

User

( 6 months ago )

 

 

Hi I am developing Exam result publishing application. I am using mysql database for this. My table structure are like this here I didn't include other basic tables

table exams

id
name
year_id
semester_id
course_id
level_id

table exam_students

id
exam_id
student_id
exam_type /* regular/partial */

table exam_results

id
exam_id
student_id
subject_id
marks

Here exams table holds a exam information and students are enrolled in that exam and that information is saved in exam_students table and the result are stored in exam_results. These are fine for a regular students(who will sit for all the subjects exam) but how do I manage the students who were failed in some subjects last time and only sit for some subjects this time(partial type)

For eg, let say we have 3 subjects x,y and z and student A failed in y subject in last exam and this time he only sit for y subject and if he get pass mark this time in y subject then we will have to publish the result of student A along with the other subjects marks that he already gained and if he fails in that subject again he have to sit for it next time. So how do I design table for this kind of logic.
Its hard for me to explain please if somebody know websites link to get the information on this it will be great help for me. Thanks for your any help and suggestion

usr_profile.png
Jadav Payeng

User

( 6 months ago )

You can have one more table named as "Repeaters". In that, you can have attributes like id, exam_id, student_id and one more that is course_id to make you aware that which course he/she is repeating.

what's your interest


forum_ban8_5d8c5fd7cf6f7.gif