Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: How to find Brothers and Sisters?

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@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 - 15:44:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US