Database design for exam system?
-
Sir! I am trying to develop a computer based Result Tabulation System for the school I work in. I have designed the tables for Teachers, Classes, Students etc. but am stuck with the design of tables for exam system itself. Can you please guide me as to how better it could be done? The examination system of school is as follows. 1. There are Two Terms in an academic year 2. There are two Bimontlhy's(BM) in each term 3. There are Four Class works(cw), One Oral Project(OP) and One Assessment Test(AT) in one Bimonthly 4. The aggregate of all the class works and OP and ATs make one Bimonlthly Its Like cw1+cw2+cw3+cw4+OP+AT = BiMonthly(BM) 5. The aggregate of two Bi Monthly and Term Exams make A Term Assements and BM1+BM2+First Term Exam = First Term I am wondering as how to make normalized tables and avoid any anomalies. Should I make separate tables for Classworks like tblClasswork: cwID, cwname, cwshort 1 , Classwork1, cw1 and same for AT and OPs. and them make a table for Bimonthly to Put CWID in it ... and then for term? I have also tried to create a table named tblExamData with fields: stuID, teacherID, subjectID, sessionID, cwID, opID, atID, bmID, termID but it won't serve the purpose coz it will store the information about CWs, Ops and Ats not the obtained marks of the students. I have also tried to change it like tblExamData: stuID, teacherID, subjectID, sessionID, cwID, cwMarks, opId, opMarks, atID, atMarks, bmID, bmMarks, termID, termMarks. but then there may be some update, delete anomalies.? what to do with it? I apologise for this long write up but i am writing in a hope to get a better guideline. thank you regards,
-
Sir! I am trying to develop a computer based Result Tabulation System for the school I work in. I have designed the tables for Teachers, Classes, Students etc. but am stuck with the design of tables for exam system itself. Can you please guide me as to how better it could be done? The examination system of school is as follows. 1. There are Two Terms in an academic year 2. There are two Bimontlhy's(BM) in each term 3. There are Four Class works(cw), One Oral Project(OP) and One Assessment Test(AT) in one Bimonthly 4. The aggregate of all the class works and OP and ATs make one Bimonlthly Its Like cw1+cw2+cw3+cw4+OP+AT = BiMonthly(BM) 5. The aggregate of two Bi Monthly and Term Exams make A Term Assements and BM1+BM2+First Term Exam = First Term I am wondering as how to make normalized tables and avoid any anomalies. Should I make separate tables for Classworks like tblClasswork: cwID, cwname, cwshort 1 , Classwork1, cw1 and same for AT and OPs. and them make a table for Bimonthly to Put CWID in it ... and then for term? I have also tried to create a table named tblExamData with fields: stuID, teacherID, subjectID, sessionID, cwID, opID, atID, bmID, termID but it won't serve the purpose coz it will store the information about CWs, Ops and Ats not the obtained marks of the students. I have also tried to change it like tblExamData: stuID, teacherID, subjectID, sessionID, cwID, cwMarks, opId, opMarks, atID, atMarks, bmID, bmMarks, termID, termMarks. but then there may be some update, delete anomalies.? what to do with it? I apologise for this long write up but i am writing in a hope to get a better guideline. thank you regards,
I am also working on the same system but this one is for the university, I will send it to you in few days be in contact with me... my cell No. is +92-333-7112553
-
I am also working on the same system but this one is for the university, I will send it to you in few days be in contact with me... my cell No. is +92-333-7112553
Yeah! thank you! Its nice to hear that you are working with a same kind of system!... Good to be in contact haa'n mine cell is +92-321-4169324 Tahir