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: Transforming 1-1-M Ternary Relationships into Logical

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@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 - 05:28:11 CDT

Original text of this message

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