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 PROTECTED
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 proble
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 t
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
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 lo
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 databa
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 f
