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 |
|
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 goodTable:QuestionQuestionidquestionnarrativequestiontype (multiple choice, true and false,etc.)Table:Question_answerQuestionIDAnswerIDAnswerSeqAnswerNarrtiveCorrect_Y/NFeedbackWrongAnswerFeedbackTable:PoolPoolIDPoolNameOwnerIDtable:Pool_QuestionPoolIDQuestionIDTable:TestTestIDTestNameTable:Test_OwnerTestIDOwnerIDTable:Test_QuestionTestID QuestionID page#Sequence#maxpointTable:Test_SectionTestIDSectionIDstarttimeendtimerandomizequestionsrandomizeanswersgradedstudentviewanaswers Numberofattempts Table:Test_Section_RetenranceCodeTestIDSectionIDRetenranceCodeStudentIDIssueDateDateUsedAttemptNoIn case of randomizationTable:Test_Student_LayoutTestIDStudentIDAttemptNoSectionIDPage#QuestionIDQuestionLayoutSequenceAttemptDateTable:Test_Student_answer_LayoutTestIDStudentIDAttemptNoSectionIDQuestionIDAnswerIDAnswerlayoutSequenceTable:Test_Student_Answers_GradeTestIDQuestionIDStudentAnswerGradeAttained (automatically generated if multiple choice /true_false)AttemptNoTable:Test_Student_AttemptTestIDSectionIDStudentIDAttemptNoStartDateEndDateTable:Test_Student_Attempt_LogTestIDSectionIDStudentIDAttemptNoPage#VisitDateTimeList of answers (Questionid:answer)Duration |
|
|
|
|
|
Test Bank data structure