What have you designed, so far, for the Questions and Answers tables?
This is what i have done so far.
original_question_id (FK to question.question_id)
(PK of this table is composed of original_question_id and version_number)
answered_question_id (FK to questions.question_id)
original_answer_id (FK to answers.answer_id)
answered_question_version_number (FK to question_history.version_number)
And do you also have a Students table and a StudentScores table? Or some other similar tables?
This design is for questionaiare form. I have created the question/answer(history) tables. Now, I have two things to ask from you. First, can you see any design flaws in what i have done. Second, how to proceed from here. I was thinking of creating a forms table but am not sure. Thank You