Re: How to find Brothers and Sisters?
From: Cimode <cimode_at_hotmail.com>
Date: 3 Dec 2006 13:44:56 -0800
Message-ID: <1165180807.819078.124800_at_n67g2000cwd.googlegroups.com>
Date: 3 Dec 2006 13:44:56 -0800
Message-ID: <1165180807.819078.124800_at_n67g2000cwd.googlegroups.com>
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.
Regards...
Received on Sun Dec 03 2006 - 22:44:56 CET