Computer Science: An Overview: Global Edition (12th Edition)

Published by Pearson Higher Education
ISBN 10: 1292061162
ISBN 13: 978-1-29206-116-0

Chapter 7 - Software Engineering - Chapter Review Problems - Page 367: 26

Answer

In a one-to-many relationship, one record in a table can be associated with one or more records in another table. For example, A museum can have many works of art. In many to many relationship, many records in a table can be associated with many records in the other table. Let’s say you have a list of books, and a list of authors—each book may have one or more authors, and each author may have written multiple books. In this case, you have many books related to many authors. => Both the concepts are explained using this diagram attached.
1566152760

Work Step by Step

In a one-to-many relationship, one record in a table can be associated with one or more records in another table. For example, A museum can have many works of art. In many to many relationship, many records in a table can be associated with many records in the other table. Let’s say you have a list of books, and a list of authors—each book may have one or more authors, and each author may have written multiple books. In this case, you have many books related to many authors. => Both the concepts are explained using this diagram attached.
Small 1566152760
Update this answer!

You can help us out by revising, improving and updating this answer.

Update this answer

After you claim an answer you’ll have 24 hours to send in a draft. An editor will review the submission and either publish your submission or provide feedback.