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

Home -> Community -> Usenet -> c.d.o.server -> Re: Implementing complicated constraints

Re: Implementing complicated constraints

From: Tony Andrews <andrewst_at_onetel.com>
Date: 30 Sep 2004 05:16:43 -0700
Message-ID: <1096546603.206373.64250@h37g2000oda.googlegroups.com> 





Mark C. Stock wrote:


> however, since the ATXT can apply to only one AID, and ATXT can only

exist


> in the context of AID, id' remove TID from table A and change table T

to:


>

> T(TID, CID ref C.CID, ATXT, C.AID) with unique constraint on CID,

ATXT and


> NN an UK on AID




That still leaves unresolved the rule that T.CID should match B.CID for
the same AID value.



It is also not normalised, since T.CID is transitively dependent on
T.AID.

Received on Thu Sep 30 2004 - 07:16:43 CDT












Original text of this message













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