Re: How to find Brothers and Sisters?

From: David Cressey <dcressey_at_verizon.net>
Date: Mon, 04 Dec 2006 15:47:23 GMT
Message-ID: <fqXch.1858$QD3.1724@trndny01>

"Cimode" <cimode_at_hotmail.com> wrote in message news:1165242357.899497.161570_at_j44g2000cwa.googlegroups.com...

>> I would think this is more a design flaw than the table not formally
>> being in 1NF. No repeating groups. check. Data in the form of a
>> relation. check. Some root entry in 'persons' who has himself or one of
>> his successors as a father... erm.....hold on...
>>
>> (I think that Marshall once pointed out that the technical term for
>> this is Furturama-NF, where Fry is his own grandfather)

> Repeating groups is not the only prerequisite to state a table is in or
> is not in 1NF.

> There is no way you can be in 1NF if NULL values are permitted OR if
> you have 2 different predicates in the same RTable...Only one predicate
> per RTable.. That's by definition. Period.

Where did you get that definition? Received on Mon Dec 04 2006 - 09:47:23 CST