General Database Terminology Question -- Mapping one table into another

From: Paul Schrum <Paul_at_geopak.com>
Date: Wed, 07 Jul 1999 15:35:06 -0400
Message-ID: <3783ABEA.22F10E35@geopak.com>

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 Wed Jul 07 1999 - 14:35:06 CDT