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

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 Fri Jul 09 1999 - 07:50:34 CDT