Experiencing MIS
8th Edition
ISBN: 9780134792736
Author: KROENKE
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 5, Problem 6CE
Modify the E-R model in Figure 5-17 to include a Contact entity that is related to the Facility entity. Create the relationship, and specify and justify the relationship’s cardinalities. For the definition of cardinality, see CE5.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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.
Analyze the given entity relationship diagram and answer the following questions.
What is the degree of “has” relationship?
Identify primary key(s)
Identify the category of each attribute
Name the cardinalities
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 5 Solutions
Experiencing MIS
Ch. 5.3 - Prob. 1SWCh. 5.3 - Prob. 2SWCh. 5.3 - Prob. 3SWCh. 5.3 - Prob. 4SWCh. 5 - Prob. 1EGDQCh. 5 - Prob. 2EGDQCh. 5 - Prob. 3EGDQCh. 5 - Prob. 4EGDQCh. 5 - Prob. 5EGDQCh. 5 - Prob. 6EGDQ
Ch. 5 - Prob. 7EGDQCh. 5 - Consider the adage Never ask a question for which...Ch. 5 - Prob. 1ARQCh. 5 - Prob. 2ARQCh. 5 - Prob. 3ARQCh. 5 - Prob. 4ARQCh. 5 - Prob. 5ARQCh. 5 - Prob. 6ARQCh. 5 - Prob. 1UYKCh. 5 - Prob. 2UYKCh. 5 - Prob. 3UYKCh. 5 - Study Figure 5-17 to understand the entities and...Ch. 5 - Working with your team, develop a list of seven...Ch. 5 - Modify the E-R model in Figure 5-17 to include a...Ch. 5 - Discuss the advantages and disadvantages of the...Ch. 5 - Transform the data model in Figure 5-17 into a...Ch. 5 - Prob. 9CECh. 5 - Fill your database with sample data. Because you...Ch. 5 - Prob. 11CECh. 5 - Prob. 12CSCh. 5 - Prob. 13CSCh. 5 - Prob. 14CSCh. 5 - Prob. 15CSCh. 5 - Prob. 16CSCh. 5 - Prob. 17CSCh. 5 - Prob. 18CSCh. 5 - Prob. 19MMLCh. 5 - Prob. 20MLM
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
- In an entity-relationship diagram, what does cardinality represent? 1:The distinct identifier for which data is kept 2:The relationship's maximum number of entity instances 3:An entity's total amount of primary keys. 4:An entity's total amount of characteristicsarrow_forwardWhat does cardinality indicate in an entity-relationship diagram? 1:The unique identification for which data is stored 2:The maximum number of entity instances for the connection 3:The total number of primary keys for an object. 4:The total number of features of an entityarrow_forwardCreation of Entity Relationship Diagram Draw the entity relationship diagram (ERD) for this information.arrow_forward
- Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation according to the below business rules. Your design should be at the logical level – include primary and foreign key fields and remember to remove any many-to-many relationships. Tip: Pay attention to the mark allocation shown below. Sheep farm feed supplier business rules: • All entities must have surrogate primary keys. • A contact person represents one or more suppliers, and each supplier has exactly one contact person. • A supplier supplies many feed products, and every feed product can be supplied by many suppliers. • Each feed product belongs to a specific feed type, and many feed products can have the same feed type.arrow_forwardDraw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation according to the below business rules. Your design should be at the logical level – include primary and foreign key fields and remember to remove any many-to-many relationships. Tip: Pay attention to the mark allocation shown below. Astronaut mission business rules:• Every entity must have a surrogate primary key.• An astronaut lives in a specific country, and many astronauts can be from the same country.• The name for each astronaut must be stored in the database.• The name for each country must be stored in the database.• An astronaut is assigned to a mission to perform a specific role on board a specific vehicle.• An astronaut and a vehicle can be assigned to multiple missions over time.• The start date and end date of each mission must be stored in the database.• The model and name of each vehicle must be stored in the database.• The description of each role must be stored in the database.arrow_forwardPRESENTATION Explain Entity Relationship Diagram, symbols, Notations, different components and create an ERD of any given scenario.arrow_forward
- Draw an ER diagram of ONLINE COURSE REGISRATION database, that captures all the given below requirements. Specify key attribute(s) of each entity set. For each relationship set, specify structural constraints and participation constraintsarrow_forwardCreate an entity relationship diagram based on the following DFD Level 0arrow_forwardIn your group, you will need to create an entity relation (E-R) diagram using the Crow's foot symbols that models the problem. This will include: Summarise the ERM's components, and names the entities and their relationship (As given in the Textbook, p.143, Table 4.4) all entities, relationships (including names) and attributes that are relevant, primary keys identified, and include relationship participation - participation (optional / mandatory) symbols and cardinality. The E-R diagram should be completed using the standards of this unit. Use Microsoft Visio to create the E-R diagram. The group should also complete the Student Contribution table for this stage of the Assignment and submit it along with your E-R diagram. Student Contribution Tablearrow_forward
- Describe data relationships, draw an entityrelationship diagram, define cardinality, and use cardinality notationarrow_forwardDraw an enhanced entity relationship diagram using the diagram belowarrow_forwardDraw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation according to the below business rules. Your design should be at the logical level – include primary and foreign key fields and remember to remove any many-to-many relationships. Astronaut mission business rules:• Every entity must have a surrogate primary key.• An astronaut lives in a specific country, and many astronauts can be from the same country.• The name for each astronaut must be stored in the database.• The name for each country must be stored in the database.• An astronaut is assigned to a mission to perform a specific role on board a specific vehicle.• An astronaut and a vehicle can be assigned to multiple missions over time.• The start date and end date of each mission must be stored in the database.• The model and name of each vehicle must be stored in the database.• The description of each role must be stored in the database.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY