SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Test Bank data structure
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Nadermfr
Starting Member

4 Posts

Posted - 11/03/2012 :  20:50:37  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000