You may want to look at this article for some ideas:
http://www.varlena.com/GeneralBits/110.php
The article talks about doing dynamic schema design for online
surveys... it's pretty interesting.
Aaron Thul
http://www.chasingnuts.com
On Wed, Oct 22, 2008 at 10:59 AM, Thom Brown [EMAIL
Thanks David and Jeff.
I can see your point. The provided link might actually be useful,
although I think I'd make some changes to it.
I wouldn't have trouble data-mining such a structure for individual
questionnaire results. The planner will be shrugging its shoulders,
but I haven't actually
On Fri, Oct 24, 2008 at 09:34:20AM +0100, Thom Brown wrote:
Thanks David and Jeff.
I can see your point. The provided link might actually be useful,
although I think I'd make some changes to it.
Good :)
It's not meant to be holy writ, just a way to see how you might
approach this problem
On Wed, Oct 22, 2008 at 03:59:07PM +0100, Thom Brown wrote:
I have previously had a questionnaire which had 5 tables, questions
and answers and question types, questionnaire and results.
This design looks a lot like the EAV (entity-attribute-value) style of
database design. This tends to be
Hi Sam, thanks for your suggestion.
I'm afraid such a rigid structure is completely tailored for a
specific questionnaire. What if I, or even a client, wanted to
generate different questionnaires? I would like the data to indicate
the flow of questions and answers rather than just use the
On Wed, Oct 22, 2008 at 03:59:07PM +0100, Thom Brown wrote:
Hi,
Is there any optimal and generally agreed way to store questionnaire
data in a database?
The questionnaire would have to support both of the following:
Without going EAV (almost always a mistake, this should get you a long
On Thu, 2008-10-23 at 21:38 +0100, Thom Brown wrote:
I'm afraid such a rigid structure is completely tailored for a
specific questionnaire. What if I, or even a client, wanted to
generate different questionnaires? I would like the data to indicate
the flow of questions and answers rather
Hi,
Is there any optimal and generally agreed way to store questionnaire
data in a database?
The questionnaire would have to support both of the following:
- different question types (e.g. What is your name? (free form text)
Are you a smoker? (yes/no checkbox) Are you male or female? (radio