Re: General Database Terminology Question -- Mapping one table into another

I vote LINK.

it's simple and people can understand it... any word more than a syllable can lose
non-technical people in a hurry.

"this table shows how data in table1 LINKs to data in table2"

You can also use the less formal:
"See all these numbers in these two columns... they mean s***[something important]..."

:)
randy

Keith Jamieson wrote:

> What you have here is a Many to Many Relationship with a link table.
>
> Paul Schrum wrote:
>
> > I am doing a presentation in the near future which includes a light
> > discussion on the internal design of the database. Specifically, our
> > design has three tables:
> >
> > FEATURE FEATURE-ELEMENT-CORRELATION VECTOR_ELEMENTS
> > ------- --------------------------- ---------------
> > ID <--------- FEATURE_ID /--> ID
> > NAME VECTOR_ELEMENT_ID ------/ COLOR
> > X1
> > Y1
> > X2
> > Y2
> >
> > My question has to do with the terminology of this practice. I use the
> > CORRELATION table in a query to filter elements based on their filter.
> > In conversations with my collegues, we call the CORRELATION table a
> > "mapping". But in giving a presentation to about 150 people, I want to
> > be sure I am using the correct word. Is "mapping" the proper term, or
> > should I use something else?
> >
> > -Paul Schrum
> > GEOPAK Corporation
> > paul_at_geopak.com
Received on Sun Jul 11 1999 - 21:40:05 CDT