Using MIS (10th Edition)
10th Edition
ISBN: 9780134606996
Author: David M. Kroenke, Randall J. Boyle
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 5, Problem 5.7CE5
Modify the E-R model in Figure 5-28 to include a Contact entity that is related to the Facility entity. Create the relationship, and specify and justify the relationship’s cardinalities.
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
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 characteristics
Chapter 5 Solutions
Using MIS (10th Edition)
Ch. 5.2 - Prob. 1EGDQCh. 5.2 - Prob. 2EGDQCh. 5.2 - Prob. 3EGDQCh. 5.2 - Prob. 4EGDQCh. 5.2 - Prob. 5EGDQCh. 5.2 - Prob. 6EGDQCh. 5.2 - Prob. 7EGDQCh. 5.2 - Consider the adage Never ask a question for which...Ch. 5.3 - Prob. 1SAQCh. 5.3 - Prob. 2SAQ
Ch. 5.3 - Prob. 3SAQCh. 5.3 - Prob. 4SAQCh. 5.8 - Prob. 1SGDQCh. 5.8 - Prob. 3SGDQCh. 5.8 - Prob. 4SGDQCh. 5.8 - Prob. 5.1ARQCh. 5.8 - Prob. 5.2ARQCh. 5.8 - Prob. 5.3ARQCh. 5.8 - Prob. 5.4ARQCh. 5.8 - How are data models used for database development?...Ch. 5.8 - Prob. 5.6ARQCh. 5.8 - Prob. 5.7ARQCh. 5.8 - Prob. 5.8ARQCh. 5 - Draw an entity-relationship diagram that shows the...Ch. 5 - Consider the relationship between Adviser and...Ch. 5 - Prob. 5.3UYKCh. 5 - Prob. 5.4UYKCh. 5 - Study Figure 5-28 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-28 to include a...Ch. 5 - Discuss the advantages and disadvantages of the...Ch. 5 - Transform the data model in Figure 5-28 into a...Ch. 5 - Prob. 5.1CE5Ch. 5 - Fill your database with sample data. Because you...Ch. 5 - Prob. 5.12CE5Ch. 5 - Explain why a one-table database could be stored...Ch. 5 - Prob. 5.14CS5Ch. 5 - Examine the columns in Figure 5-33. Name three...Ch. 5 - Prob. 5.16CS5Ch. 5 - Prob. 5.17CS5Ch. 5 - Explain the statement A database is an abstraction...Ch. 5 - Prob. 5.19CS5Ch. 5 - Prob. 5.2MMLCh. 5 - Prob. 5.21MML
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
- Creation of Entity Relationship Diagram Draw the entity relationship diagram (ERD) for this information.arrow_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_forwardb. 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.arrow_forward
- PRESENTATION Explain Entity Relationship Diagram, symbols, Notations, different components and create an ERD of any given scenario.arrow_forwardHow does the primary key of one entity function as a foreign key on the other side of a many-to-one relationship?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. 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_forward
- Draw a complete ER Diagram. Show all entities, attributes, primary keys, foreign keys, relationships and connectivities involved in the diagram. (Using LucidChart)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_forwardCreate an entity relationship diagram based on the following DFD Level 0arrow_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. 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_forwardUndertake a thorough analysis of the scenario and identify: 1. Entity types 2. Relationship types 3. Attributes and attributes domains. 4. Primary keys and alternate keysarrow_forwardDescribe the process of creating an entity-relationship diagram (ERD). Provide a complex real-world scenario and design an ERD to represent it.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
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