Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SweetoSyed
Starting Member
4 Posts |
 Posted - 2007-06-25 : 06:39:19
|
| Hi all! I have already design some tables for student info system of a school with student and teachers table. Now i want to design tables for exam system and i am stuck up as how better it could be done.The exam system is as followsThere are Two Terms in an academic yearThere are two bimontlhy's(BM) in each termThere are Four Class works(cw), One Oral Project(OP) and One Assessment Test(AT)Its Like cw1+cw2+cw3+cw4+OP+AT = BiMonthly(BM)and BM1+BM2+First Term Exam = First TermI have student, teacher, subject, classes table design, what better structure could be of exam and assessment for all the classworks, bimonthly and term exams?looking to have some positive ideas.thank youregards,Tahir |
|
|
|
|
|
Examination System Database Design