But if you want to select candidates according
to 17 different responses, then you have a
seventeen table join - which isn't too great.
And, of course, your total storage size is
massive compared to a 1-row = 1 paper solution.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Practical Oracle 8i: Building Efficient Databases
Publishers: Addison-Wesley
Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
Daniel A. Morgan wrote in message <3ACC18EA.5C5881CA_at_exesolutions.com>...
>I'm glad you asked. Still the wrong solution. The correct solution is:
>
>Questionnaire_no NUMBER(3),
>Question_no NUMBER(3),
>Answer_value CHAR(1)
>
>or something like that. Think vertically not horizontally. The above table
would
>hold an unlimited number of questionnaires with an unlimited number of
>questions. That some something impossible to handle if you try it the other
way.
>
>Daniel A. Morgan
>
>
>Jonathan Lewis wrote:
>
>> How about a multi-choice questionnaire with
>> 100 (or 300) questions, and a group of market
>> researchers who want to ask for completely
>> arbitrary results - you MIGHT set this up as
>> a wide table with bitmap indexes on every column.
>>
Received on Thu Apr 05 2001 - 12:56:43 CDT
