Re: How to find Brothers and Sisters?

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.

My money is on the nullable father. Received on Mon Dec 04 2006 - 05:02:12 CET