[thelist] online quiz database structure

[Emma Jane Hogbin]

On Sun, Jul 20, 2003 at 03:15:36PM -0400, Emma Jane Hogbin wrote:
> I can only think of two options at this point:
> 	- remove qanswer from the survey_questions and create another table
> 	  that holds question_rightanswer
> 	- change the qanswer column to a varchar and allow a string of comma
> 	  separated answers

I've decided on a third option. The "right answer" information now resides
with the answer table instead of the question table. I've also eliminated
the answer_question relationship table. Now the answer table holds which
question it is tied to (since each answer can only be used in one
question).

emma :)

-- 
Emma Jane Hogbin
[[ 416 417 2868 ][ www.xtrinsic.com ]]