Experiencing MIS
7th Edition
ISBN: 9780134380421
Author: KROENKE
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
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 solution
Students have asked these similar questions
Draw 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 DIAGRAM
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.
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.
Chapter 5 Solutions
Experiencing MIS
Ch. 5.3 - Prob. 1SWCh. 5.3 - Prob. 2SWCh. 5.3 - Prob. 3SWCh. 5.3 - Prob. 4SWCh. 5.3 - Prob. 5SWCh. 5 - Prob. 1EGDQCh. 5 - Prob. 2EGDQCh. 5 - Prob. 3EGDQCh. 5 - Prob. 4EGDQCh. 5 - Prob. 5EGDQ
Ch. 5 - Prob. 6EGDQCh. 5 - Prob. 7EGDQCh. 5 - Consider the adage Never ask a question for which...Ch. 5 - Prob. 1GDQCh. 5 - Prob. 2GDQCh. 5 - Prob. 3GDQCh. 5 - Prob. 4GDQCh. 5 - Prob. 5GDQCh. 5 - Prob. 6GDQCh. 5 - Prob. 7GDQCh. 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. 19MLMCh. 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
- Create an entity relationship diagram based on the following DFD Level 0arrow_forwardDraw 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.arrow_forwardDraw an enhanced entity relationship diagram using the diagram belowarrow_forward
- To manage the materials of a factory, please give the E-R diagrams. Such entity sets are involved as below: Warehouse: with attributes as Number, area and telephone Accessory : with attributes as number, Name, Specification, price and description Supplier: with attributes as Number, name, address, telephone and асcount Project : with attributes as number and budget Employee : with attributes as number, name and agearrow_forwardDraw an ER diagram for the airport database. Be sure to indicate the various attributes of each entity and relationship set; also specify the key and participation constraints for each relationships. Specify any necessary overlap and covering constraints The FAA passes a regulation that tests on a plane must be conducted by a technician whois an expert on that model. How would you express this constraint in the ER diagram? If you cannot express it, explain briefly.arrow_forwardBuild an entity-relationship diagram, deriving relations and validating relations using normalization up to third normal formarrow_forward
- In 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 diagramarrow_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_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_forward
- IBased 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_forwardyou 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 Table) Table 4.4 Components of the ERM Entity Relationship Connectivity Entity SCHOOL operates 1:M DEPARTMENT DEPARTMENT has 1:M STUDENT DEPARTMENT employs 1:M PROFESSOR DEPARTMENT offers 1:M COURSE COURSE generates 1:M CLASS SEMESTER includes 1:M CLASS PROFESSOR is dean of 1:1 SCHOOL PROFESSOR chairs 1:1 DEPARTMENT PROFESSOR teaches 1:M CLASS PROFESSOR advises 1:M STUDENT STUDENT enrolls in M:N CLASS BUILDING contains 1:M ROOM ROOM is used for 1:M CLASS Note: ENROLL is the composite entity that implements the M:N relationship “STUDENT enrolls in CLASS.” all entities, relationships (including names), and…arrow_forwarddraw 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_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