Re: Complicated query

On 12/12/2014 1:20 AM, Geoff Muldoon wrote:
> 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.

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