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


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



Copyright © www.teach-ict.com