For the exam management system...
I have made an observation:
The number of questions for each question may vary...
So, I wanted to use something like an array...
but thats isnt possible in databases it seems.
so,
according to the srs...
we have an EXAM table.. which contained the arr_questions and arr_answers.
we could do one thing:
leave out the arr_questions and arr_answers from the exam table.. ( the other attributes remain intact)
we'll use another table called:
QUESTIONS( question_id,exam_id, question,answer)
hence, exam_id will reference the EXAM table... question_id will be the foreign key...
howzzat...??
post comments and questions...
I have made an observation:
The number of questions for each question may vary...
So, I wanted to use something like an array...
but thats isnt possible in databases it seems.
so,
according to the srs...
we have an EXAM table.. which contained the arr_questions and arr_answers.
we could do one thing:
leave out the arr_questions and arr_answers from the exam table.. ( the other attributes remain intact)
we'll use another table called:
QUESTIONS( question_id,exam_id, question,answer)
hence, exam_id will reference the EXAM table... question_id will be the foreign key...
howzzat...??
post comments and questions...
Shoubhik- You have mentioned about the question storing procedure in Database!
ReplyDeletebt u didnt mention that we hav to design the page that automatically recv the answer sheet after a certain time period!
if the page is refreshed by any user then how he handles the prblm!
it can be developed if we add an auto checking facility of mcq question! if the questions r Mcq then for every user the questions r shuffled!
yes, we shall put up auto checking facility.
ReplyDeleteThe answers will be pre-inserted into the system by the faculty who creates the question paper.
Right, i was reading about stored procedures.. but i thought that could be complicated...
in fact, i was trying the facebook way of handling databases.