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
Please, can you DRAW the NEW ER diagram to comply with the new requirements requested, and also indicate what type of cardinality each of the relationships between the entities has.
Creation of Entity Relationship Diagram
Draw the entity relationship diagram (ERD) for this information.
Draw the Entity Relationship Diagram (ERD) as explained below. Be sure to show cardinality in both directions using Crows Foot notation. Do NOT include the fields/attributes or keys for each entity
The business rules to create the Crow’s Foot ERD are:
A department employs many employees, but each employee is employed by only one department.
Some employees, known as “rovers,” are not assigned to any department.
A division operates many departments, but each department is operated by only one division.
An employee may be assigned many projects, and a project may have many employees assigned to it.
A project must have at least one employee assigned to it.
One of the employees manages each department, and each department is managed by only one employee.
One of the employees runs each division, and each division is run by only one employee.
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
- Draw this ER Diagram, but note that: Ths diagram should adhere to compressed Chen notation : The ER diagram consists of four entities: Pet, Challenge, User, and Vote. The Pet entity has attributes such as id (primary key), name, species, age, and description to store information about each pet profile. The Challenge entity has attributes such as id (primary key), pet1_id and pet2_id (foreign keys referencing the Pet entity), start_date, end_date, and likes to store information about each challenge between two pets. The User entity has attributes such as id (primary key), name, and email to store information about users who participate in voting and challenge creation. The Vote entity has attributes such as id (primary key), challenge_id (foreign key referencing the Challenge entity), user_id (foreign key referencing the User entity), and vote to store information about user's vote for a particular challenge.arrow_forwardThe below Entity Relationship Diagram (ERD) is in second normal form. Draw anew ERD in third normal form and explain the changes. diagram belowarrow_forwardCreate an entity relationship diagram based on the following DFD Level 0arrow_forward
- 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.arrow_forwardDraw an Entity Relationship Diagram of Store Management System(Retail Store Database). Properly mention the entities, identify the relationships and find the cardinality of each relation very carefully. At this point of time your ERD should be final and not any major changes should occur. Properly mention following: a. Entity b. Relationship c. Attributes d. Cardinality iF HAND WRITTEN THE DIAGRAM SHOULD BE NEAT DO NOT POST COPIED DIAGRAMarrow_forwardDraw an enhanced entity relationship diagram using the diagram belowarrow_forward
- PRESENTATION Explain Entity Relationship Diagram, symbols, Notations, different components and create an ERD of any given scenario.arrow_forwardIBased on the given case scenario, 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 all entities, relationships (including names) and attributes that are relevant, primary keys identified, and include relationship participation - participation (optional / mandatory) symbols and cardinality. Case Study The following business rules are provided from the description of operations: A customer may request many charter trips. Each charter trip is requested by only one customer. Some customers have not (yet) requested a charter trip. Every charter trip is requested by at least one customer. An employee may be assigned to serve as a crew member on many charter trips. Each charter trip may have many employees assigned to it to serve as crew members. An employee may not yet have been assigned to serve as a crew member on…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_forward
- Use the following business rules to create a Crow’s Foot Entity Relationship Diagram. Write all appropriate connectivities and cardinalities in the ERD. Add other linking entities as needed. • A department employs many employees, but each employee is employed by one department. • Some employees, known as “rovers,” are not assigned to any department. • A division operates many departments, but each department is operated by one division. • An employee may be assigned many projects, and a project may have many employees assigned to it. • A project must have at least one employee assigned to it. • One of the employees manages each department, and each department is managed by only one employee. • One of the employees runs each division, and each division is run by only one employee.arrow_forwardAnalyze 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 cardinalitiesarrow_forwardTelephone DVD Number Code Member Cost Name Tle Date Out Date In Number (RM) 1012 Inobel Ringer 293847 003 American Ple 2.50 1 Jan 2014 2 Jan 2014 011 My Grandpa in My Pocket 2.00 2 Jan 2014 3 Jan 2014 1034 John Siver 142536 002 Finding Nemo 3.50 17 Feb 2014 18 Feb 2014 015 Shrek 4.00 28 Feb 2014 1 March 2014 1056 Fred Flinstone 817263 003 American Pie 2.50 3 March 2014 4 March 2014 011 My Grandpa in My Pocket 2.00 13 March 2014 14 March 2014 1097 Annette Kirton 384756 008 Frozen 4.00 2 April 2014 3 April 2014 014 Prime Suspect 2.00 3 April 2014 4 April 2014arrow_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 EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable 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