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_at_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..
Date: 2 Oct 2006 14:56:46 -0700
Message-ID: <1159826206.689005.164820_at_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 - 23:56:46 CEST