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

Home -> Community -> Usenet -> comp.databases.theory -> Transforming 1-1-M Ternary Relationships into Logical

Transforming 1-1-M Ternary Relationships into Logical

From: <miklesw_at_gmail.com>
Date: 2 Oct 2006 14:56:46 -0700
Message-ID: <1159826206.689005.164820@m7g2000cwm.googlegroups.com> 





Most text books state that Ternary relationships are implemented as a
table with FKs for all the relations.. i was wondering how are 1-1-M
relationships implemented..



It seems pointless to me... In 1-M binary relationships.. the FK is
placed on the M end...


In this case it would make sense to put 2 FKs in the Many end..



What is the proper way of implementing this?



Tnx,



Mike
Received on Mon Oct 02 2006 - 16:56:46 CDT












Original text of this message













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