Describe the many-to-many relationship and give an example of it.

The many to many relationship, is the type of relationship that occur when various records in the table are basically related with the different records in the another table.

In many to many relationship table, the parent row of the one table basically represent the the child row of the another table.

For example: clients can buy different items, and items can be acquired by numerous clients, in this it represent the customer and the product relationship.