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: Using FKs to non PK unique-indexes

Re: Using FKs to non PK unique-indexes

From: <before.the.gods_at_gmail.com>
Date: 11 Feb 2006 08:21:04 -0800
Message-ID: <1139674864.573235.94660@g14g2000cwa.googlegroups.com> 





Hello Brian



Consider the following data



CLIENTS



client1


client2



PRODUCTS



product1


product2



CLIENTS_PRODUCTS



clientproduct1  client1  product1


clientproduct2  client2  product2



ORDERS



order1  client1



ORDERS_PRODUCTS



orderproduct1  order1  clientproduct2




It is exactly the situation I want to avoid.  In ORDERS_PRODUCTS, I got
a pair of client/product that does not belong to the client that placed
order1.  The integrity plan you proposed failed to discard this
situation



BTG

Received on Sat Feb 11 2006 - 10:21:04 CST












Original text of this message













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