8. Many-to-many relationships

Example of a many-to-many relationship

Think about videos in a video hire shop and the shop's customers.

A video can be hired by many customers

Customers can hire many videos

this would be known as a 'many-to-many relationship'

This relationship can be portrayed diagramatically as:

many to many relationship

IMPORTANT

When designing database relationships, many-to-many relationships are not a good idea.

 

many to many

 

challenge see if you can find out one extra fact on this topic that we haven't already told you

Click on this link: Many-to-many relationship