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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Non-unique index and normalization

Re: Non-unique index and normalization

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 01 May 2002 19:07:52 GMT
Message-ID: <3CD03D05.6A430B90@exesolutions.com> 





John Hunter wrote:



> Is there a normalization rule that indicates that there must be an unique PK

> key on every table in the database?  I am having a debate with a co-worker

> and one of us says that there has to be one and the other disagrees.  Who is

> right?

>

> Thanks,

> -John




While it may exist in theory, Celko and others can answer that far better than
I, no such rule exists in practice.



Daniel Morgan
Received on Wed May 01 2002 - 14:07:52 CDT












Original text of this message













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