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
Videos
Textbook Question
Chapter 5, Problem 5.5CE5
Study Figure 5-28 to understand the entities and their relationships. Justify each of the cardinalities in this model.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Illustrate an Entity-Relationship Diagram (ERD) model using Crow’s Foot notation
Here we can have the following entities
1.patients:this entity will store the details of the patients and the attributes for this entity is
id(which is unique for each patient and can be used as a primary key)
name(this attribute will store the name of the patient and it is a composite attribute)
address(this attribute will store the address of the patient and it is multi valued attribute. )
contact_num(this is also a multi valued attribute which will store the contact details of the patient).
age(which is a derived attribute)
2.room:this entity will store the information about the details of the rooms. The attributes are.
id(this is unique for each room and can be used as a primary key)
room number(this will store the room number)
Total_bed(this will store the total number of beds present in that room)
3. Bed:this entity will store the information regarding to each bed present in an room, and the…
Analyze the given entity relationship diagram and answer the following questions.
What is the degree of “has” relationship?
Explain what does it mean when an attribute of one entity type refers to another entity type?
Give an example and show how this should be represented in ER Model.
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
- Suppose you are working within the framework of the conceptual model in Figure Q4.5. FIGURE Q4.5 THE CONCEPTUAL MODEL FOR QUESTION 5arrow_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_forwardEvery flimsy entity set may be strengthened by the addition of pertinent characteristics. What therefore, is the cause of our subpar entity sets?arrow_forward
- Use ER Assistant to draw your diagram. Transform the following M-N relationship into an associative entity type and two identifying 1-M relationships.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_forwardGiven the ER diagram to the right, which entity types deserve to stay entity types and which ones should be converted to attribute? Explain why.arrow_forward
- In the ER-Model, what are the guidelines for properly recognizing entities and developing connections between them?arrow_forwardPlease provide a definition of an entity-relationship model as well as an explanation of how it works.arrow_forwardSuppose that we wish to keep a genealogy. The information we wish to record about each person includes their name, date of birth, phone number, and degrees obtained . We also need to keep track of the mother, father, and children of each person. Draw a complete Entity-Relationship diagram. You must include all the details, sad as keys, weak entities (if any), cardinality constraints, etc. Your diagram must avoid redundancy.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. Business rules for hairdressers: 1. All entities should have surrogate primary keys. 2. Each hairdresser can work at multiple different salons over time, and every salon employs many different hairdressers. 3. The job title of a hairdresser at a specific salon must be stored in the database. 4. The name and surname of each hairdresser must be stored in the database. 5. The name of each salon must be stored in the database. 6. Every hairdresser is certified to have several different skills, and each skill can be mastered by many different hairdressers. 7. The name of each skill must be stored in the database. 8. The date that a specific hairdresser was certified to have a specific skill must be stored in the database.arrow_forwardDraw an entity relationship diagram ERD using unified modelling language UML nation according to the below business rules. your design should be logical level-including primary and foreign key fields and remember to remove any many-to-many relationships. 1. all entities should have surrogate primary keys. 2.A customer can place many orders over and over time and each order is placed by exactly one customer. 3.The name and surname of a customer must be stored in the database 4.The date and status of an order must be stored in the database 5.Each order cab obtain many items and each item can be part of many different orders 6.The name description and unit price of every item must be stored in the database 7.When an item is added to an order, the quality ordered and the unit price of thr item must be stored 8.Each item in the database belongs to a catagory and a catagory has many items that belong to it 9.The name of each of the categories must be stored in the databasearrow_forwardWhat is the purpose of entity-relationship diagrams? What sort of symbol is used to depict a connection, and how does it work? What exactly does the phrase "associative entity" imply and what does it mean? Give an example.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database 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 ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher: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
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY