Database Concepts (8th Edition)
8th Edition
ISBN: 9780134601533
Author: David M. Kroenke, David J. Auer, Scott L. Vandenberg, Robert C. Yoder
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 4, Problem 4.21RQ
Define the term associative entity, and give an example other than one used in this text. Your example should start with a N:M relationship between two strong entities and then be modified by an additional data requirement. Draw IE Crow’s Foot E-R diagrams for both your N:M relationship and for the relationships among the three entities that include the associative entity.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Analyze the given entity relationship diagram and answer the following questions.
What is the degree of “has” relationship?
Translate the E/R diagram that you draw in the previous question into a set of relations, clearly marking all references and keys. Also explain your translation with a paragraph.
thats the previous question :Draw an Entity Relationship diagram for modeling the following system. Use relational modelling techniques in your design. You are free to make reasonable assumptions for your model unless they conflict with the definition below. Also explain your design with a paragraph. [Caution: Create your solution using paper and pen. Then put the image of your solution here. Drawing/writing with computer tools will not be accepted. Also include your name and signature in the solution paper]Problem definition: “There is a need to keep track of data for a hospital. The hospital building consists of several departments. Each department is identified with its name. For each department, the following data should also be stored: the number of floors, opening hour, and closing hour. Each…
Draw an Entity Relationship diagram for modeling the following system. Use relational modelling techniques in your design. You are free to make reasonable assumptions for your model unless they conflict with the definition below. Also explain your design with a paragraph. [Caution: Create your solution using paper and pen. Then put the image of your solution here. Drawing/writing with computer tools will not be accepted. Also include your name and signature in the solution paper]Problem definition: “There is a need to keep track of data for a hospital. The hospital building consists of several departments. Each department is identified with its name. For each department, the following data should also be stored: the number of floors, opening hour, and closing hour. Each department has a number of rooms. Each room is identified by its room number, but there might be rooms with the same name in different departments. At each department, many doctors and nurses can work.A doctor is…
Chapter 4 Solutions
Database Concepts (8th Edition)
Ch. 4 - Prob. 4.1RQCh. 4 - Prob. 4.2RQCh. 4 - Prob. 4.3RQCh. 4 - What is a use case, and what is its purpose?Ch. 4 - Give an example of a data constraint.Ch. 4 - Prob. 4.6RQCh. 4 - Define the term entity, and give an example other...Ch. 4 - Explain the difference between an entity class and...Ch. 4 - Define the term attribute, and give examples for...Ch. 4 - Define the term identifier, and indicate which...
Ch. 4 - Prob. 4.11RQCh. 4 - Prob. 4.12RQCh. 4 - Prob. 4.13RQCh. 4 - Prob. 4.14RQCh. 4 - List and give an example of the three types of...Ch. 4 - Prob. 4.16RQCh. 4 - Prob. 4.17RQCh. 4 - Prob. 4.18RQCh. 4 - Define the term weak entity, and give an example...Ch. 4 - Explain the ambiguity in the definition of the...Ch. 4 - Define the term associative entity, and give an...Ch. 4 - Define the terms supertype, subtype, and...Ch. 4 - What is an exclusive subtype relationship? Give an...Ch. 4 - What is an inclusive subtype relationship? Give an...Ch. 4 - Prob. 4.25RQCh. 4 - Prob. 4.26RQCh. 4 - Prob. 4.27RQCh. 4 - Prob. 4.28RQ
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
- Data modelling is most often accomplished through the use of a(an) ________________. a. entity-relationship diagram b. data-flow diagram c. functional decomposition diagram d. activity diagramarrow_forwardFor the entity-relationship model expressed in the IE diagram below, what is the minimum number of tables required to implement it in BCNF. (Image attached). Enter the number below.arrow_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
- Suppose 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_forwardSpecifically, on which side of a many-to-one connection does the primary key of one entity function as a foreign key? There is a huge number of relationships specified on one side of the diagram. both from the inside and the outside It is possible to define two relationships at the same time. On the one hand, one connection is defined; on the other, another relationship is defined.arrow_forwardUsing the above table structure, create a normalized Entity-Relationship Model (ERM). Identify Primary Key(s) and Foreign Key(s) for all the entities, connectivities and/or cardinalities, and relationships between the entities. As for Chen's ERM notation and the normalization, the level should be in Third Normal Form (3NF) and above. [Note: you do notneed to show the normalization process such as the functional dependency diagram.]arrow_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_forwardUse ER Assistant to draw your diagram. Draw a self-referencing entity type for the Employee entity type for which an employee is supervised by a maximum of one other employee and doesn’t have to be supervised by any employee at all. Conversely, an employee can supervise zero or many other employees. The attributes of the Employee entity are as follows: EmpNo (primary key), EmpName, EmpAddress.arrow_forward
- We can convert any weak entity set to a strong entity set by simply adding appropriate attributes. Why, then,do we have weak entity sets? (a) We want to avoid the data duplication and consequent possible inconsis- tencies caused by duplicating the keyof the strong entity set.(b) Weak entities reflect the logical structure of an entity being dependent on another entity.(c) Weak entities can be deleted automatically when their strong entity is deleted.(d) All of the above.arrow_forwardThe difference between a weak entity set and a strong entity set should be explained.arrow_forwardDescribe how functional dependencies may be used to show: • There is a many-to-one connection set between the entity sets student and instructor, as well as a one-to-one relationship set between the two.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
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