Skip navigation links

MySQL Forums :: General :: Database design for multiple choice questionnaire results?


Advanced Search

Re: Database design for multiple choice questionnaire results?
Posted by: timb ()
Date: October 19, 2004 07:42AM

For my much smaller surveys, multiple-choice questions get just one tinyint column with possible values of 1, 2, 3, etc. up to the number of answers available for that question. This assumes that the respondent may only select one answer for each question. Only questions where the respondent is allowed to select more than one answer have a column for each answer.

If even half of your 600 survey questions are single answer only that would reduce the number of columns from 3,000 to 1,800 and allow indexing of the single answer columns (300 indexes instead of 1,500).

Options: ReplyQuote


Subject Written By Posted
Database design for multiple choice questionnaire results? qwerty awerty 10/18/2004 10:55AM
Re: Database design for multiple choice questionnaire results? Mike Hillyer 10/18/2004 11:21AM
Re: Database design for multiple choice questionnaire results? qwerty awerty 10/18/2004 11:54AM
Re: Database design for multiple choice questionnaire results? timb 10/19/2004 07:42AM
Re: Database design for multiple choice questionnaire results? qwerty awerty 10/19/2004 01:09PM
Re: Database design for multiple choice questionnaire results? rgschoonheim 10/22/2004 02:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.