Re: storing survey answers of different data types

From: Gene Wirchenko <genew_at_ocis.net>
Date: Thu, 23 Apr 2009 18:59:30 -0700
Message-ID: <2172v49io99a65rha8l78cssblu5ph0v86_at_4ax.com>



"Joe Thurbon" <usenet_at_thurbon.com> wrote:

[snip]

>My name is Joe, I have property in Australia, my house if 40 years old.

     Hi, my name is Gene. I do not have any real estate, but I live in an apartment in Canada. My apartment is about fifteen years old.

>Just wondering, if one of the requirements for a system included
>something like 'Be able to list all questionnaires', would
>you still consider one-table-per-questionairre a reasonable design?

     Sure. See my other post. It is easy to list a questionnaire. One need not even look at the questionnaire responses tables.

>I think that there is a more abstract question trying to get out
>of my head. Maybe it's: 'When relations become things that
>have facts asserted about them, should one stop treating them as
>relations, and normalise further?" (where normalise is almost certainly
>the wrong word, but I'm not sure what the right one is.)

     Relations always have facts asserted about them. Their structure is a fact asserted about it.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:

     I have preferences.
     You have biases.
     He/She has prejudices.
Received on Thu Apr 23 2009 - 20:59:30 CDT

Original text of this message