MODERN DATABASE MGMT.(PEARSON CHANNEL)
13th Edition
ISBN: 9780136709299
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 2, Problem 2.20RQ
For the Manages relationship in Figure 2-12a, describe one or more situations that would result in different cardinalities on the two ends of this unary relationship. Based on your description for this example, do you think it is always clear simply from an E-R diagram what the business rule is that results in certain cardinalities? Justify your answer.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
For the Manages relationship in Figure 2-12a, describe one or more situations that would result in different cardinalities on the two ends of this unary relationship. Based on your description for this example, do you think it is always clear simply from an E-R diagram what the business rule is that results in certain cardinalities? Justify your answer
draw an E-R diagram that indicates the entity sets and their attributes. Identify and label significant relationship sets between pairs of entities, the degree of relationship sets and the cardinality and participation constraints.
b. Draw an Entity Relationship diagram from each of the following descriptions. Include the attributes, primary keys (underlines) and the relationships in the diagram (like relationship in Access).
i. Each of the department has many employees assigned to it, but each employee works for only one department.
if. A customer can rent many videotapes from the video store. Each of the videotapes can be rented to many customers.
Chapter 2 Solutions
MODERN DATABASE MGMT.(PEARSON CHANNEL)
Ch. 2 - Define each of the following terms: entity type...Ch. 2 - Match the following terms and definitions....Ch. 2 - Contrast the following terms: stored attribute;...Ch. 2 - Prob. 2.4RQCh. 2 - Prob. 2.5RQCh. 2 - Prob. 2.6RQCh. 2 - State six general guidelines for naming data...Ch. 2 - Prob. 2.8RQCh. 2 - Prob. 2.9RQCh. 2 - State three conditions that suggest the designer...
Ch. 2 - List the four types of cardinality constraints,...Ch. 2 - Give an example, Other than those described in...Ch. 2 - What is the degree of a relationship? List the...Ch. 2 - Give an example (Other than those described in...Ch. 2 - Give an example of each of the following, other...Ch. 2 - Give an example of the use of effective (or...Ch. 2 - State a rule that says when to extract an...Ch. 2 - Prob. 2.18RQCh. 2 - In addition to explaining what action is being...Ch. 2 - For the Manages relationship in Figure 2-12a,...Ch. 2 - Explain the distinction between entity type and...Ch. 2 - Why is it recommended that every ternary...Ch. 2 - A cellular operator needs a database to keep track...Ch. 2 - Prob. 2.24PAECh. 2 - Answer the following questions concerning Figure...Ch. 2 - Prob. 2.26PAECh. 2 - You may have been assigned a CASE or a drawing...Ch. 2 - Consider the two E-R diagrams in Figure 2-25 Q,...Ch. 2 - Prob. 2.29PAECh. 2 - Are associative entities also weak entities? Why...Ch. 2 - Because Visio does not explicitly show associative...Ch. 2 - Figure 2-26 shows a grade report that is mailed to...Ch. 2 - Prob. 2.33PAECh. 2 - The Is Married To relationship in Figure 2-12a...Ch. 2 - Figure 2-27 represents a situation of students who...Ch. 2 - Figure 2-28 shows two diagrams (A and B), both of...Ch. 2 - Prob. 2.37PAECh. 2 - Review Figure 2-8LQ and Figure 2-22. Identify any...Ch. 2 - Prob. 2.39PAECh. 2 - Prob. 2.40PAECh. 2 - Prob. 2.41PAECh. 2 - Prob. 2.42PAECh. 2 - Prob. 2.43PAECh. 2 - Prob. 2.44PAECh. 2 - Prob. 2.45PAECh. 2 - Prob. 2.46PAECh. 2 - Prob. 2.47PAECh. 2 - Prob. 2.48PAECh. 2 - Draw an ERD for the following situation. (State...Ch. 2 - Prob. 2.50PAECh. 2 - Prob. 2.51PAECh. 2 - Review your answer to Problem and Exercise 2-49 if...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Specifically, on which side of a many-to-one connection does the primary key of one entity function as a foreign key? There is a huge number of relationships specified on one side of the diagram. both from the inside and the outside It is possible to define two relationships at the same time. On the one hand, one connection is defined; on the other, another relationship is defined.arrow_forwardDraw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notationaccording to the below business rules. Your design should be at the logical level – include primaryand foreign key fields and remember to remove any many‐to‐many relationships. Business rules for a horse‐riding competition:1. All entities should have surrogate primary keys.2. Each rider may only represent a single club, but each club may enter many riders into thecompetition.3. The name of each club must be recorded in the database.4. The name and surname of each rider must be recorded in the database.5. Each rider may only ride one horse, and every horse may only have one rider.6. The name of each horse must be recorded in the database.7. A horse may compete in multiple different events, and each event will have many horsesthat compete in it.8. The name of each event must be stored in the databasearrow_forwardGive a simple example of an E-R diagram for each concept and then write the business rules for each example. associative entity weak entity unary relationshiparrow_forward
- Draw an Entity Relationship Diagram for all of those below. Draw an ER diagram to represent information about students. A student is identified by his/her student number. Student’s name (first and last), permanent address, phone number, gender and date of birth are also stored. An airplane has a registration number, type, number of economy class seats, number of business class seats and the year of production. Some students live in student halls. Each hall has a name (unique) and an address. Each student has a number (unique) and a name. Assume that there are students living in every hall. Each text book has a unique ISBN (International Standard Book Number), and contains several chapters. Each chapter has a chapter number (unique within a book), the number of pages and the number of references. A chapter covers a single topic, but the same topic may be covered in various books. Each lecturer is identified by a unique number, name and phone. A lecturer teaches several courses, and for…arrow_forwardThe question is in the image below.arrow_forwardYou are given an E-R diagram with two entities Orders and Customers. What does the lone between the Customers entity and the Place relationship represent?arrow_forward
- Construct an Entity Relationship Diagram (ERD) in Crow’s Foot Notation for the following Nationwide City Express shipping system. Be certain to indicate identifiers and cardinality constraints. You may state any assumptions that you make. Nationwide City Express (NCE) prides itself on having up-to-date information on the processing and current location of each shipped item. To do this, NCE relies on a company-wide information system. Shipped items are the heart of the NCE product tracking information system. Shipped items can be characterized by item number (unique), weight, dimensions, insurance amount, destination, and final delivery date. Shipped items are received into the NCE system at a single retail center. Retail centers are characterized by their type, uniqueID, and address. Shipped items make their way to their destination via one or more standard NCE transportation events (i.e., flights, truck deliveries). These transportation events are characterized by a unique…arrow_forwardCreate an ER DIAGRAM that shows relationship between eachother and post the picture please . An Inventory entity can be associated with zero or many Beer entities. A Beer entity can be associated with one and only one Inventory entity. An Inventory entity can be associated with zero or one Brewery entity. A Brewery entity can be associated with zero or many Inventory entities. An Employee entity can be associated with one and only one Brewery entity. A Brewery entity can be associated with zero or many Employee entities. An Employee entity can be associated with zero or many Order entities. An Order entity can be associated with one and only one Employee entity. These business rules assume that a brewery company has an inventory of beers, which are brewed by one or more breweries and supplied by one or more suppliers. The breweries employ one or more employees and can receive orders for their beers.arrow_forwardFor each entity, there needs to be an indication of whether it is one-to-one, one-to-many or many-to-many relationship. Here are the answers I have but I could use more guidance with it. I struggle with this type of question. BOOK and BOOK COPY (1:1) COURSE and COURSE-SECTION (M:N) COURSE-SECTION and ROOM (M:1) INSTRUCTOR and COURSE (1:M) ROOM and INSTRUCTOR (M:1)arrow_forward
- Question 3 Draw a complete ER diagram using Crow's foot notation based on the given business rules below: A sales representative can write many invoices. (In a business environment, each invoice represents a sales transaction. Given the "commission set" label, one might infer that the sales rep earns a commission on each sale for which an invoice is written) Each invoice is written by a single sales representative. A customer can generate many invoices. (Each time a customer makes a purchase of one or more items, and invoice is generated) Each invoice is generated by a single customer. Each invoice includes one or more invoice lines. (Each item purchased is recorded in an invoice line) Each invoice line is associated with one (and only one) invoice. Each invoice line records a single product. Each product can be recorded in many invoice lines. (If the inventory contains 100 hammers, each one may be sold and, therefore, each of those 100 hammers may at some point be recorded in an…arrow_forwardWhat is the precise definition of a weak entity type? What is the undisclosed information? Could you please provide an example? What is the definition of alternative specialization?What is my representation on the Entity-Relationship (ER) diagram? Please provide more context or information about the example and diagram you are referring to. What subject or topic is this related to?arrow_forwardDraw an Entity relationship diagram (ER) for a university according to the following rules: ‐ For each student the university needs to keep track of: first name, last name, student id, address, phone no and their major. ‐ The student id is identical for each ‐ Each course has a number, name and credit. The course number is unique for each course. ‐ Each department has a name, code and The code is unique for each department. ‐ Each course may has one or more sections where each section is belong to only one ‐ A department offers one or many 7-‐ Some courses have perquisite courses. 8-‐ Each student could register in one or more courses. In your diagram you need to show the following: 1-‐ The primary key for each entity. 2-‐ The cardinality and participation between entities.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY