Many-to-Many Relationship
A relationship where rows on both sides can relate to many rows on the other side. It cannot be stored with a single foreign key, so it is resolved with a junction table.
When to use
PP 02 Q1.4 and PP 04 Q2 ask how to implement it: add a third table with two foreign keys. PP 03 Q4.2 rules it out as the answer when a query involves only two tables.
See PP 02.