Many-to-Many Relationship in DBMS

DBMSDatabaseMySQL

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.

raja
Published on 12-Jul-2018 20:03:38
Advertisements