Quote:
|
What have you designed, so far, for the Questions and Answers tables?
|
This is what i have done so far.
question
--------
question_id (PK)
question_text
question_history
----------------
original_question_id (FK to question.question_id)
version_timestamp
question_text
version_number
(PK of this table is composed of original_question_id and version_number)
answers
-------
answer_id (PK)
answer_text
answered_question_id (FK to questions.question_id)
answer_history
----------------
original_answer_id (FK to answers.answer_id)
version_timestamp
answer_text
answered_question_version_number (FK to question_history.version_number)
Quote:
|
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