MySQL Forums
Forum List  »  General

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

Written By
Re: Database design for multiple choice questionnaire results?
October 19, 2004 07:42AM

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.