Associative Table

n.

Pronunciation

/əˈsoʊ.ʃi.ə.tɪv ˈteɪbəl/, /əˈsoʊ.si.ə.tɪv ˈteɪbəl/

Definition

A database table that maps many to many relationships between two or more other tables.

Associative Table houses unique identifiers for records from different tables. New records in the Associative Table match these identifiers and create the relationship between the records.

Category

Data Modeling

Related Terms

Dependent Entitiy, Database, Relationship, Unique Identifier

Product Information Encyclopedia

©2020 by Industrial Data Associates, Inc.

4041 N. Milwaukee, Suite 301, Chicago, IL 60641, US

Logo-2CRev-34px-TM.png