Modern Database Management (12th Edition)
12th Edition
ISBN: 9780133544619
Author: Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 2, Problem 2.31PAE
Because Visio does not explicitly show associative entities, it is not clear in Figure 2-22 which entity types are associative. List the associative entities in this figure. Why are there so many associative entities in Figure 2-22?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Make the entity-relationship model in Luicdchart for the following case:
In the company Tecno1818 it is necessary to carry out an inventory of the products that are handled, for this the following information is available. Each product has a code, name, price and a manufacturer code. For the manufacturer you have the code and name
Create an Entity-Relationship Model to represent the data requirements of the problem given below. Specify the cardinalities of relationships and all-important constraints. Also mention the assumptions if you have made any.
A Medical store has many branches throughout country. The data held on each branch is the branch address made up of street, city, and zip code, and telephone number. Each branch is given a branch number, which is unique throughout the country. Each branch is allocated at least one staff member. Each staff member must belong to exactly one branch. The data held on a member of staff is his or her name, position and salary. Each member of staff is given a staff number, which is unique throughout the country. Each branch has a one or many products. A product belongs to exactly one or many branches. The data held on a product is the product number (identifier), title, category, price, and available quantity. Each product is purchased from exactly one vendor. From one…
Specifically, 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.
Chapter 2 Solutions
Modern Database Management (12th Edition)
Ch. 2 - Define each of the following terms: entity type...Ch. 2 - Prob. 2.2RQCh. 2 - Contrast the following terms: stored attribute;...Ch. 2 - Prob. 2.4RQCh. 2 - Prob. 2.5RQCh. 2 - Prob. 2.6RQCh. 2 - State six general guidelines for naming data...Ch. 2 - Prob. 2.8RQCh. 2 - Prob. 2.9RQCh. 2 - State three conditions that suggest the designer...
Ch. 2 - List the four types of cardinality constraints,...Ch. 2 - Prob. 2.12RQCh. 2 - What is the degree of a relationship? List the...Ch. 2 - Give an example (Other than those described in...Ch. 2 - Give an example of each of the following, other...Ch. 2 - Give an example of the use of effective (or...Ch. 2 - State a rule that says when to extract an...Ch. 2 - Prob. 2.18RQCh. 2 - In addition to explaining what action is being...Ch. 2 - For the Manages relationship in Figure 2-12a,...Ch. 2 - Explain the distinction between entity type and...Ch. 2 - Why is it recommended that every ternary...Ch. 2 - A cellular operator needs a database to keep track...Ch. 2 - For each of the descriptions below, perform the...Ch. 2 - Answer the following questions concerning Figure...Ch. 2 - Prob. 2.26PAECh. 2 - You may have been assigned a CASE or a drawing...Ch. 2 - Consider the two E-R diagrams in Figure 2-25 Q,...Ch. 2 - The entity type STUDENT has the following...Ch. 2 - Are associative entities also weak entities? Why...Ch. 2 - Because Visio does not explicitly show associative...Ch. 2 - Figure 2-26 shows a grade report that is mailed to...Ch. 2 - Prob. 2.33PAECh. 2 - The Is Married To relationship in Figure 2-12a...Ch. 2 - Prob. 2.35PAECh. 2 - Figure 2-28 shows two diagrams (A and B), both of...Ch. 2 - Prob. 2.37PAECh. 2 - Review Figure 2-8LQ and Figure 2-22. Identify any...Ch. 2 - Prob. 2.39PAECh. 2 - Prob. 2.40PAECh. 2 - Prob. 2.41PAECh. 2 - Prob. 2.42PAECh. 2 - Prob. 2.43PAECh. 2 - Prob. 2.44PAECh. 2 - Prob. 2.45PAECh. 2 - Prob. 2.47PAECh. 2 - Prob. 2.48PAECh. 2 - Draw an ERD for the following situation. (State...Ch. 2 - Prob. 2.50PAECh. 2 - Prob. 2.51PAECh. 2 - Review your answer to Problem and Exercise 2-49 if...
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
- b. 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_forwardExplain how functional dependencies can be used to indicate the following: A one-to-one relationship set exists between entity sets student and Instructor. A many-to-one relationship set exists between entity sets student and instructor.arrow_forwardGive Some additional examples of strong and weak entity pairs?arrow_forward
- Explain how weak entity representation differs from strong entity representation.arrow_forwardIn what way is it different between a weak entity and a strong entity that must have a connection with another entity?arrow_forwardTo 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_forward
- Build an entity-relationship diagram, deriving relations and validating relations using normalization up to third normal formarrow_forwardWhat does an associative entity model? a.) Associative entities model pure relationships rather than entities. b.) Associative entities model entities that are independent. c.) Associative entities model the real-world scenarios of ways to look up data. d.) Associative entities model attributes and how they are linked to entities.arrow_forwardTurn the following ER Diagram into a collection of relation schemas. Identify as many of the constraints as possible. Note: Courses is a weak entity set, and Number is a discriminator because it can be used to differentiate different courses once the department Code is given. Courses Depts Number: int. Title: varchar(30) Credit: int Code: char(4) Name: varchar(20) Budget: int GivenBy TaughtBy Instructors WorksIn ID: int FName: varchar(20) LName: varchar(20)arrow_forward
- How to convert a weak entity set into a strong entity set?arrow_forwardApplying your knowledge in Enhanced Entity Relationship modeling, Develop an EER model for the following situation: A person may be employed by one or more organizations and each organization may be the employer of one or more persons. An organization can be internal organizational unit or an external organization. For persons and organizations, we want to know their ID, name, address and phone number. For persons we want to know their birthdate, and for organizations, we want to know their budget number. For each 6 employment, we want to know the employment date, termination date and bonus. Employment of a person by an organization may result in the person holding many positions over time. For each position, we know its title, and each time someone holds that position, we need to know the start date and termination date and salary. An organization is responsible for each position. It is possible for a person to be employed by one organization and hold a position for which another…arrow_forwardExplain how functional dependencies may be used to indicate: • The entity sets student and teacher have a one-to-one relationship set.• Between entity setsstudent and teacher, there is a many-to-one connection set.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