|
Nadermfr
Starting Member
4 Posts |
 Posted - 11/03/2012 : 20:50:37
|
I would like to design online testing system. Questions can be shared between tests.
Please is the following db structure good
Table:Question
Questionid
questionnarrative
questiontype (multiple choice, true and false,etc.)
Table:Question_answer
QuestionID
AnswerID
AnswerSeq
AnswerNarrtive
Correct_Y/N
Feedback
WrongAnswerFeedback
Table:Pool
PoolID
PoolName
OwnerID
table:Pool_Question
PoolID
QuestionID
Table:Test
TestID
TestName
Table:Test_Owner
TestID
OwnerID
Table:Test_Question
TestID
QuestionID
page#
Sequence#
maxpoint
Table:Test_Section
TestID
SectionID
starttime
endtime
randomizequestions
randomizeanswers
graded
studentviewanaswers
Numberofattempts
Table:Test_Section_RetenranceCode
TestID
SectionID
RetenranceCode
StudentID
IssueDate
DateUsed
AttemptNo
In case of randomization
Table:Test_Student_Layout
TestID
StudentID
AttemptNo
SectionID
Page#
QuestionID
QuestionLayoutSequence
AttemptDate
Table:Test_Student_answer_Layout
TestID
StudentID
AttemptNo
SectionID
QuestionID
AnswerID
AnswerlayoutSequence
Table:Test_Student_Answers_Grade
TestID
QuestionID
StudentAnswer
GradeAttained (automatically generated if multiple choice /true_false)
AttemptNo
Table:Test_Student_Attempt
TestID
SectionID
StudentID
AttemptNo
StartDate
EndDate
Table:Test_Student_Attempt_Log
TestID
SectionID
StudentID
AttemptNo
Page#
VisitDateTime
List of answers (Questionid:answer)
Duration
|
Edited by - Nadermfr on 11/04/2012 01:17:11
|
|
Test Bank data structure
