Dear all,
i am creating an application for student online exam.
there are two type of questions , single choice of answer , and multi choices of answers.
my question table is below
create table question_master
(
exam_id number references exam_master(exam_id),
marks_of_each_question number,
type_of_question char(1),-- single choice answer/multiple choices answer
q1 varchar2(2000),
q2 varchar2(2000),
q3 varchar2(2000),
q4 varchar2(2000))
my answer table(i am not satisfied of which is below
create table answers_of_questions
(
answer_id number primary key,
question_ID number referenes question_master(question_id),
answer varchar2(4000) not null,
is_answer_correct char(1),--y/n,
student_selection char(1),--y/n student select it or not
....
...
now i am wonder how to create the ANSWER table to hold the answers.
for single choice , it is okay, but for multiple choices checkboxes, what to do?
how to design the answer table?
do i have to create 2 tables to hold the answers?
note : the QUESTIONS and ANSWERS all will be entered by teacher. student will make a choice and i will store that choice in another table
may be called STUDENT_SELECTED_ANSWERS or something like that.
if anybody have some reference regarding the online exam schema detail script, kindly share with me.
Regards.
regards.