Re: Doing Summation on multiple criterias on the same column in a
am 01.04.2008 17:22:54 von jhofmeyr> Anyway, you are still clearly either missing the point or intentionally
> disregarding it. =A0This is not about lemonade; this is about the fact tha=
t
> some things are just yes/no indicators on their own, without "help" from
> other facts. =A0If you don't get it, you don't get it, and I'm afraid I ca=
n't
> help to educate you any further. =A0:-(
To my (mostly) unbiased eye, it looks like both sides are missing the
point (either intentionally or otherwise)... Joe has already said
that he accepts that there are rare cases where a 2 value domain is
valid, but that in *most* cases modelling a flag is not "correct".
But we all know that Joe's only interested in "correct" from a
standards and theoretical perspective though, so it is pointless to
argue the application of flags from a practical perspective.
=46rom a purely theoretical perspective I can see his point ... from a
practical perspective I have no problem disregarding his point if it
makes sense in the context of the problem I'm facing :)
For example (and in keeping with the theme of this thread), I've heard
that in market research it is fairly normal to build a database purely
to record the results of a single survey. This is essentially a throw-
away piece of work that exists only to analyse data from that single
survey, the reason being that it's more cost-effective than building a
"proper" database to store more generic survey results. In this
scenario it is a waste of time to design flexibility into the database
as the analysis is usually predefined by whatever research model the
company is using. The results of the analysis however, would likely
be stored in a well designed database to be compared against past/
future surveys...
J