Path: news.netfront.net!goblin1!goblin.stu.neva.ru!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail
From: Shelly <sheldonlg@thevillages.net>
Newsgroups: comp.databases.mysql
Subject: Re: Complicated query
Date: Fri, 12 Dec 2014 08:04:26 -0500
Organization: A noiseless patient Spider
Lines: 28
Message-ID: <m6ep3u$s4u$1@dont-email.me>
References: <m5v08f$4kc$1@dont-email.me> <1vfpx8req13ag.a3n36ahpsxl3.dlg@40tude.net> <m65okf$a49$2@dont-email.me> <m683ar$pjq$1@dont-email.me> <m6ckh2$jd8$1@dont-email.me> <m6cpa6$8fs$1@dont-email.me> <m6cqe7$df9$1@dont-email.me> <m6doob$hna$1@dont-email.me> <m6dsme$r5o$1@dont-email.me> <MPG.2ef5343c33c7fae5100@news.albasani.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Fri, 12 Dec 2014 13:03:58 +0000 (UTC)
Injection-Info: mx02.eternal-september.org; posting-host="1dddffd56a2512e1104380042d395e61";
 logging-data="28830"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX1/I7iqxhgLwdBvKzZzD95BuvB+lt/GE5NA="
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.6.0
In-Reply-To: <MPG.2ef5343c33c7fae5100@news.albasani.net>
Cancel-Lock: sha1:NtRUFqmH69u9Fh5+/BsMotp8P4A=
Xref: news.netfront.net comp.databases.mysql:2292

On 12/12/2014 1:20 AM, Geoff Muldoon wrote:
> In article <m6dsme$r5o$1@dont-email.me>, sheldonlg@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.

Sorry, but those were the two impressions I got from your post.  I guess 
with respect to normalization I got the wrong impression.  I still 
disagree with you that it is not normalized.

> 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.

Yes, you are correct. I said it wrong.

-- 
Shelly