how to present many to many relationship
how to present many to many relationship
When records from one table are linked to those from another, there is a many-to-many relationship present. A database table with a list of books and a table with a list of writers can serve as an example of a many-to-many relationship. Each book may have one or more authors, and each author may be the author of a single book or several. In this instance, a row in one table is closely related to numerous rows in another table. Additionally, the rows in the first table are also related to the rows in the second table.
In databases, junction tables are used to accommodate a many-to-many link between tables.The primary key columns of the two tables you want to relate are contained in a junction table.
Step by step
Solved in 2 steps with 2 images
