Re: Transforming 1-1-M Ternary Relationships into Logical
Date: 4 Oct 2006 02:08:37 -0700
Message-ID: <1159952917.260505.22560_at_e3g2000cwe.googlegroups.com>
You are using an incorrect terminology. You believe a relationship is
a pointer that allows to design cardinalities (it is not). The proper
way for you to deal with the problem you are describing is to do some
serious reading about relational model...Here is the reference...Hope
this helps...
Introduction to Database Theory by CJ DATE
miklesw_at_gmail.com wrote:
> 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 Wed Oct 04 2006 - 11:08:37 CEST