Many-To-Many

 

For modeling Many-To-Many relationships, a third (Associative) table is used to associate two indirectly related tables. The Associative table contains a Foreign Key for the Primary Keys in the two “Many” tables.

Example: Groups > Group Participants > Participants

A Group can have many Participants. A Participant can be in many Groups