Database Concepts (8th Edition)
8th Edition
ISBN: 9780134601533
Author: David M. Kroenke, David J. Auer, Scott L. Vandenberg, Robert C. Yoder
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 5, Problem 5.20RQ
Explanation of Solution
Many-to-many relationship (N:M):
Many-to-many relationship is one of the types of binary relationship that refers to the relationship that is laid between the two entities which means that many records in a table are associated with many records in another table.
Example:
In a library
IE crow’s foot ER diagram:
Information Engineering is a method to represent the relationship between the entities. It uses crow’s foot to denote the many sides of a relationship. Hence, it is referred to as IE crow’s feet ER diagram.
- Relational database system will not allow the user to implement a direct many-to-many relationship. Therefore, the many-to-many relationship will break into two one-to-many relationships the using third table and it is called “intersection table”...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Describe how the relationship (1:M) of an E-R diagram is transformed into relations
Describe how the relationship (M:N) of an E-R diagram is transformed into relations
Design an Entity-Relationship for each system described below. Use the (min,max) notation. State clearly any additional assumptions you make.
Give the relational model by applying the mapping rules (WITH REFERENCES AND ARROWS).
NOTE: USE CHEN ER DIAGRAM (YOU CAN USE VISIO MICROSOFT(TEMPLATE=CHEN) ONLY SHOWING THE ENTITIES/ATTRIBUTES/WEAK ENTITIES/RELATIONSHIPS/PRIMARY KEY-FK/ (MIN-MAX) NOTATIONS ALSO NOT FORGETTING THE REFERENCES ON THE MAPPING TABLES WITH ARROWS REFERRING THE FOREIGN KEYS. YOUR WORK SHOULD BE SPECIFIC WITH JUSTIFICATION.
We want to build a database for a community of paleontologists, storing information about the fossils kept in different museums.
Each fossil is described by the year and place of discovery, the name of the paleontologist who discovered it, the room where it is exposed, and the presumed species. Each fossil may be assigned to different species with different degrees of probability.
Museums are characterized by their rooms, their paleontologists and…
Chapter 5 Solutions
Database Concepts (8th Edition)
Ch. 5 - Explain how entities are transformed into tables.Ch. 5 - Prob. 5.2RQCh. 5 - Prob. 5.3RQCh. 5 - What is denormalization?Ch. 5 - Prob. 5.5RQCh. 5 - Explain the problems that denormalized tables may...Ch. 5 - Explain how the representation of weak entities...Ch. 5 - Explain how supertype and subtype entities are...Ch. 5 - Prob. 5.9RQCh. 5 - Prob. 5.10RQ
Ch. 5 - Show two different ways to represent the 1:1...Ch. 5 - Prob. 5.12RQCh. 5 - Prob. 5.13RQCh. 5 - Prob. 5.14RQCh. 5 - Prob. 5.15RQCh. 5 - Prob. 5.16RQCh. 5 - For your answer to question 5.15, code an SQL...Ch. 5 - Prob. 5.18RQCh. 5 - Prob. 5.20RQCh. 5 - Prob. 5.21RQCh. 5 - Explain how the terms parent table and child table...Ch. 5 - For your answers to questions 5.20, 5.21, and...Ch. 5 - Prob. 5.24RQCh. 5 - Prob. 5.25RQCh. 5 - Prob. 5.26RQCh. 5 - Prob. 5.27RQCh. 5 - Prob. 5.28RQCh. 5 - Define the three types of recursive binary...Ch. 5 - Prob. 5.30RQCh. 5 - Prob. 5.31RQCh. 5 - Prob. 5.32RQCh. 5 - Prob. 5.33RQCh. 5 - Prob. 5.34RQCh. 5 - Code an SQL statement that creates a table with...
Knowledge Booster
Similar questions
- Design an Entity-Relationship for each system described below. Use the (min,max) notation. State clearly any additional assumptions you make. Give the relational model by applying the mapping rules (WITH REFERENCES AND ARROWS). NOTE: USE CHEN ER DIAGRAM (YOU CAN USE VISIO MICROSOFT(TEMPLATE=CHEN) ONLY SHOWING THE ENTITIES/ATTRIBUTES/WEAK ENTITIES/RELATIONSHIPS/PRIMARY KEY-FK/ (MIN-MAX) NOTATIONS ALSO NOT FORGETTING THE REFERENCES ON THE MAPPING TABLES WITH ARROWS REFERRING THE FOREIGN KEYS. YOUR WORK SHOULD BE SPECIFIC WITH JUSTIFICATION. We consider a library that contains books that can be borrowed. A book is characterized by a unique number, a title, an author and a publisher. In addition, we describe a book by a number of keywords that indicate the treated subjects. The library has one or more copies of each book; the copy is identified by a number and characterized by its position on the shelves and the date of purchase. A copy can be borrowed by a borrower. This latter is…arrow_forwardDesign an Entity-Relationship for each system described below. Use the (min,max) notation. State clearly any additional assumptions you make. Give the relational model by applying the mapping rules (WITH REFERENCES AND ARROWS). NOTE: USE CHEN ER DIAGRAM (YOU CAN USE VISIO MICROSOFT(TEMPLATE=CHEN) ONLY SHOWING THE ENTITIES/ATTRIBUTES/WEAK ENTITIES/RELATIONSHIPS/PRIMARY KEY-FK/ (MIN-MAX) NOTATIONS ALSO NOT FORGETTING THE REFERENCES ON THE MAPPING TABLES WITH ARROWS REFERRING THE FOREIGN KEYS. YOUR WORK SHOULD BE SPECIFIC WITH JUSTIFICATION. Consider a Mail_Order database in which employees take orders for parts from customers. The data requirements are summarized as follows: The mail order company has employees, each identified by a unique customer number, first and last name, and ZIP code. Each customer of the company is identified by a unique customer number, first and last name, and ZIP code. Each part sold by the company is identified by a unique part number, a part name, price,…arrow_forwardThey said S is a binary relation. I 100% do not understand what this (the picture) means at all. If you can include a diagram and another way to explain what S is, that would be great!arrow_forward
- Perform given tasks on Case study Q-Find entity Attribute and primary key, also draw Entity diagram? Case study: In a college we have students, department, teachers and courses. A student has name registration No and address. A teacher has name NIC and qualification. A department is known by its name e.g. CSIT, and have a HOD name , Num of students and Floor No. A course is identified by its Code. Course also has name and level of degree. A student must enroll (roll no and Semester as relationship attribute) in any one department. A department can have many students. The teacher is assigned class (time and day as attribute) in more than one department. A department has many teachers. A student can study up-to 5 courses by a teacher in given classroom number.arrow_forwardCan you just draw this out on a piece of paper with the relationships??arrow_forwardWhat is the purpose of entity-relationship diagrams? What sort of symbol is used to depict a connection, and how does it work? What exactly does the phrase "associative entity" imply and what does it mean? Give an example.arrow_forward
- Just what does it imply when we talk about weak entities? The key is... Please provide an example Just what does "various specialization" entail?Where do I fit into the ER diagram, if at all? Provide a case study and accompanying illustration.arrow_forwardDescribe how the weak entity of an E-R diagram is transformed into relationsarrow_forwardWhat is Concept Map? Explain your answer.arrow_forward
- Translate the E/R diagram that you draw in the previous question into a set of relations, clearly marking all references and keys. Also explain your translation with a paragraph. thats the previous question :Draw an Entity Relationship diagram for modeling the following system. Use relational modelling techniques in your design. You are free to make reasonable assumptions for your model unless they conflict with the definition below. Also explain your design with a paragraph. [Caution: Create your solution using paper and pen. Then put the image of your solution here. Drawing/writing with computer tools will not be accepted. Also include your name and signature in the solution paper]Problem definition: “There is a need to keep track of data for a hospital. The hospital building consists of several departments. Each department is identified with its name. For each department, the following data should also be stored: the number of floors, opening hour, and closing hour. Each…arrow_forwardPLZ help with the following: Create a Crow’s Foot ERD. Draw YOUR entity relationship diagram (ERD) to indicate entities, relationships, connectives, and resolve M:N relationships. For the following: The faculty and students (we refer to them in our system as clients) can electronically check out any book at any time. A book must have at least one author but can have more authors. An author must have written at least one book or more to be included in the system. A book may have neverbeen checked out, but can be checked out many times by the same client or different clients over time. A client may have never checked out a book or they may have checked out many books over time. To simplify determining which client currently has a given book checked out, a M:N relationship between BOOK and CLIENT should be maintained. The information recorded for each book is book number, book title, book subject, and year of publication. For each author, the library records the author ID,…arrow_forwardWhat exactly does it imply when we talk about the weak entity type? What exactly is the key? Please provide an example. What exactly is meant by the term "alternative specialisation"?Where exactly do I fit into the ER diagram? Provide an illustration, then draw a diagram that corresponds to it.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning