Re: Complicated query
From: Jerry Stuckle <jstucklex_at_attglobal.net>
Date: Mon, 15 Dec 2014 13:50:09 -0500
Message-ID: <m6nagd$7r9$1_at_dont-email.me>
>
>
>
> It depends on what the questions are and what the collective group of
> answers to the question set represents.
>
> eg (my first example):
>
> title?
> firstname?
> lastname?
> dateOfBirth?
>
> That's part of a person record, and I doubt many people would consider
> the table:
>
> create table person (title varchar(10), firstname varchar(20), lastname
> varchar(20), dateOfBirth date);
>
> to violate first normal form.
>
> Do we debate whether firstname and lastname are in the same domain now? ;)
>
Date: Mon, 15 Dec 2014 13:50:09 -0500
Message-ID: <m6nagd$7r9$1_at_dont-email.me>
On 12/15/2014 10:47 AM, Denis McMahon wrote:
> On Mon, 15 Dec 2014 08:16:59 -0500, Jerry Stuckle wrote:
>
>> On 12/15/2014 1:10 AM, Denis McMahon wrote:
>
>>> If in the OPs case the answers are actually a mix of strings, dates, >>> numbers and booleans, then I guess this coercion has already been done, >>> given that the Op was presenting us with a single table of answers, but >>> again, there may be cases where having all the answers to a single set >>> of questions in a single record might not violate normal forms, which >>> is where I'm going with this.
>
>> I don't see where this does not violate first normal form. You would >> have multiple columns in the same domain.
>
> It depends on what the questions are and what the collective group of
> answers to the question set represents.
>
> eg (my first example):
>
> title?
> firstname?
> lastname?
> dateOfBirth?
>
> That's part of a person record, and I doubt many people would consider
> the table:
>
> create table person (title varchar(10), firstname varchar(20), lastname
> varchar(20), dateOfBirth date);
>
> to violate first normal form.
>
> Do we debate whether firstname and lastname are in the same domain now? ;)
>
No, firstname and lastname are not in the same domain. They are two different items. Unlike 5 answers to one question, which would be in the same (answers) domain.
-- ================== Remove the "x" from my email address Jerry Stuckle jstucklex_at_attglobal.net ==================Received on Mon Dec 15 2014 - 19:50:09 CET