Re: Complicated query

From: Geoff Muldoon <geoff.muldoon_at_invalid.invalid>
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

Original text of this message