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.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Test Bank data structure

Author  Topic 

Nadermfr
Starting Member

4 Posts

Posted - 2012-11-03 : 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
   

- Advertisement -