DB Design Recommendations Needed
I have a project I am revamping. It has a database which stores Tests and Test Questions. As it is now, it is structured like so:
tblExam:
ID ExamNumber ExamName QuestionID TeacherID
1 1 Quiz 43 62
2 1 Quiz 44 62
3 1 Quiz 45 62
4 2 Test 304 62
5 3 Test 305 62
6 4 Test 306 62
etc.
Now if I were to design this from scratch, I probably would have made 2 tables, one for the Exam specific fields, and the other with the exam questions....like this:
tblExam:
ID ExamNumber ExamName ExamDate (etc.)
1 1 Quiz 01-01-2005
2 1 Test 02-01-2005
etc.
and
tblExamQuestions:
ID ExamNumber QuestionID QuestionWeight
1 1 43 33
2 1 44 33
3 1 45 33
4 2 304 5
5 2 305 5
6 2 306 5
etc.
Of course moving things around like this would require a rewrite of some of the underlying SQL and some class work as well.
One other thing to note is that I am adding more fields to the Tables as well, like the ExamDate field (and some other Exam options) and the QuestionWeight field (and some other questions options)
I am wondering what pros and cons are to these two designs and if a change is worth my effort...
-------------------------
Beware of programmers with screwdrivers...
__________________
-------------------------
Beware of programmers with screwdrivers...
|
