Re: Transforming 1-1-M Ternary Relationships into Logical

From: <miklesw_at_gmail.com>
Date: 4 Oct 2006 03:28:11 -0700
Message-ID: <1159957690.968291.218140_at_i42g2000cwa.googlegroups.com>


What do you mean by "A pointer that allows to design cardinalities"? I'm not following..

Cimode wrote:
> 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 - 12:28:11 CEST

Original text of this message