A linking table is a table used to transform a many-to-many relationship between tables into two one-to-many relationships; usually composed mostly of foreign keys.

Question

Quizplus · Accepted Answer

A linking table, also known as a junction table or associative entity, is used in database design to break down a many-to-many relationship into two one-to-many relationships, facilitating the relational database's normalization. It typically contains the primary keys from the two tables it links as foreign keys.

A Linking Table Is a Table Used to Transform a Many-To-Many