Re: Database design for multiple choice questionnaire results?

[rgschoonheim]

Hello,

you might consider grouping the answers bit-wise. When you have 3000 questions, you cloud group response in pairs of 24. This way you create a 24-bit value for every 24 answers. Totaly you get about 125 columns. Selections and countings can be done with the Bit-operators.
This solutions only fits your counting / response-relations problem as it can't store actual values, like you sugested by filling de DB with 1's and 0's.

good luck!