Re: How to find Brothers and Sisters?

From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Mon, 04 Dec 2006 04:02:12 GMT
Message-ID: <85Nch.28354$cz.427464@ursa-nb00s0.nbnet.nb.ca>

Lennart wrote:

> Cimode wrote:
>

>>Lennart a écrit :
>>
>>>drop table persons;
>>>create table persons (
>>>      name char(10) not null primary key,
>>>       father char(10) references persons on delete restrict,
>>>       gender char(1) not null check (gender in ('M','F'))
>>>);
>>
>>While getting demanded results, the above schema is not 1NF.

>
> Really, in what way do you think the schema violate 1NF?
>
> /Lennart

My money is on the nullable father. Received on Sun Dec 03 2006 - 22:02:12 CST