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: Foreign key problem

Re: Foreign key problem

From: Kenneth Downs <knode.wants.this_at_see.sigblock>
Date: Tue, 13 Jun 2006 16:22:29 -0400
Message-Id: <hdj3m3-fcr.ln1@pluto.downsfam.net>


mAsterdam wrote:

> By using _child, and _parent suffixes
> (which, BTW, by themselves do /not/
> facilitate more than one FK in one table
> referencing one other) you are mixing
> the language in the universe of modeling
> (the language used to describe your model)
> with the language of the universe it models.
>
> By using roles for naming foreign keys you stay
> within the language of the modeled universe and
> it naturally facilitates more than one FK in one
> table referencing /one/ other.

Methinks this is deeper than we have found we need to go.

But before I judge prematurely, can you elaborate with an example?

-- 
Kenneth Downs
Secure Data Software, Inc.
(Ken)nneth@(Sec)ure(Dat)a(.com)
Received on Tue Jun 13 2006 - 15:22:29 CDT

Original text of this message

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