Re: Complicated query
Date: Fri, 12 Dec 2014 17:20:30 +1100
Message-ID: <MPG.2ef5343c33c7fae5100_at_news.albasani.net>
In article <m6dsme$r5o$1_at_dont-email.me>, sheldonlg_at_thevillages.net
says...
> Now, as Geoff Muldoon has responded, you may want to have a table of
> questions and an table of answers and an instance table that has foreign
> keys to those tables for other reasons (like expansion and
> modification), but even he agrees that doing it with just one table is
> *NOT* a violation of normal form.
Excuse me, please do not misrepresent what I said.
I certainly did NOT agree it is a not violation of normalisation rules. I said that regardless of any debate over whether it is or isn't (and it IMHO is) it's a STUPID design.
And furthermore you still got it wrong:
You want a table of questions and an table of instances (not answers),
with a table of answers (not instances) that has foreign keys to those
tables.
Do you not understand any of the basic underlying theory? Never heard of Codd? Multivalued dependencies?
GM Received on Fri Dec 12 2014 - 07:20:30 CET