| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: How to find Brothers and Sisters?
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
![]() |
![]() |