Many-to-Many Relationship in DBMS

Many-to-Many relationship in DBMS is a relationship between more than one instance of an entity with more than one instance of another entity i.e. both the entities can have many relationships between each other.

The relation can be stated as −

Let us see an example −

Many Authors can write a Book, whereas an Author has written more than one book.

Here, Book and Author are entities.

Let’s say a book has two authors, whereas an individual author has written six books till now.

Updated on: 15-Jun-2020

8K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started