Re: How to find Brothers and Sisters?

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 Received on Sun Dec 03 2006 - 20:58:46 CST