Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 3, Problem 3.23PAE
Figure 3-13 shows the development Of entity clusters for the Pine Valley Furniture E-R diagram. In Figure 3-13b, explain the following:
- Why is the minimum cardinality next to the DOES BUSINESS IN associative entity coming from CUSTOMER zero?
- What would be the attributes of ITEM (refer to Figure 2-22)?
- What would be the attributes of MATERIAL (refer to Figure 2-22)?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Based on the set of 3NF relations derived in (b), draw a complete entity relationship diagram (ERD) using Chen notation. Make sure that all the entities, attributes, relationships and connectivities are included in your ERD
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 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…
A customer can make many payments, but each payment is made by only one customer.” Use this scenario as the basis for an entity relationship diagram (ERD) representation using either Chen, Crow’s Foot or UML Class Diagram.
Chapter 3 Solutions
Modern Database Management
Ch. 3 - Define each of the following terms: supertype...Ch. 3 - Match the following terms and definitions:...Ch. 3 - Contrast the following terms: supertype; subtype...Ch. 3 - State two conditions that indicate when a database...Ch. 3 - Prob. 3.5RQCh. 3 - Give an example (other than those discussed in the...Ch. 3 - What is the attribute inheritance? Why is it...Ch. 3 - Give an example of each of the following: a...Ch. 3 - What types of business rules are normally captured...Ch. 3 - What is the purpose of a subtype discriminator?
Ch. 3 - Prob. 3.11RQCh. 3 - In what ways is starting a data modeling project...Ch. 3 - Prob. 3.13RQCh. 3 - Prob. 3.14RQCh. 3 - What do you purchase when you acquire a packaged...Ch. 3 - In Figure 3-5b, why must the minimum cardinality...Ch. 3 - When is a member of a supertype always a member of...Ch. 3 - Examine the hierarchy for the university EER...Ch. 3 - Add a subtype discriminator for each of the...Ch. 3 - For simplicity, subtype discriminators were left...Ch. 3 - Refer to the employee EER diagram in Figure 3-2....Ch. 3 - Refer to the EER diagram for patients in Figure...Ch. 3 - Figure 3-13 shows the development Of entity...Ch. 3 - Refer to Problem and Exercise 2-44 in Chapter 2...Ch. 3 - For a library, the entity type HOLDING has four...Ch. 3 - A bank has three types of accounts: checking,...Ch. 3 - Refer to your answer to Problem and Exercise 2-4...Ch. 3 - Refer to your answer to Problem and Exercise 3-24...Ch. 3 - Prob. 3.29PAECh. 3 - Draw an EER diagram for the following situation:...Ch. 3 - Develop an EER model for the following situation,...Ch. 3 - Prob. 3.32PAECh. 3 - Prob. 3.33PAECh. 3 - Prob. 3.34PAECh. 3 - Based on the EER diagram constructed for Problem...Ch. 3 - Prob. 3.36PAECh. 3 - Prob. 3.37PAECh. 3 - Add the following to Figure 3-16: An EMPLOYMENT...
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
- 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_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_forwardBy adding the primary-key characteristics of the identifying entity set in its attributes, a weak entity set may always be converted into a strong entity set. Describe the kind of redundancy that will result from our choice.arrow_forward
- Create an ER Diagram for an Bank. Identify atleast 5 entity in the ER Diagram Identify atleast one weak entity. Identify atleast 3 attributes for each entity. Identify atleast one attribute that is: Composite Multivalued attribute Derived attribute Represent all the key(primary) attributes by suitable notations/symbol. Represent the Cardinality and Modality using Crow’s foot notation. Identify atleast one specialization/generalization.arrow_forwardDATABASE REPORT 1、How to map ….? Step 1: Mapping of Regular Entity Types. Step 2: Mapping of Weak Entity Types Step 3: Mapping of Binary 1:1 Relation Types Step 4: Mapping of Binary 1:N Relationship Types. Step 5: Mapping of Binary M:N Relationship Types. Step 6: Mapping of Multivalued attributes. Step 7: Mapping of N-ary Relationship Types. 2、For example: Create an ER model for each of the following descriptions: (a) Each Company operates four Departments, and each Department belongs to one Company. (b) Each Department in part(a) employs one or more Employees, and each Employee works for one Department with a startdate. (c) Each of the Employees in part (b) may or may not have one or more Dependents, and each Dependent belongs to one Employee. (d) suppose: Company with attributes cnumber, cname, caddress, President. Department with attributes dname, dnumber, location. Employee with attributes ename, ssn(for social security number), Sex, address, salary,…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
- If you are reading a flat file, with minimal information regarding business rules and constraints. How can one determine the appropiate relationships between entities? This question refers to entity relationship modeling. Logical ERDs.arrow_forwardwhich relationship or association is depicited in the following entity relationship (ER) diagram? Salesperson sales Product a) Uniary b) One to many c) Associative Entity d) Intersection Dtaarrow_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_forward
- Consider the below ERD in Figure 03 of Student Enrolment system and answer the below questions. List the strong (non-weak) entity types in the ER diagram. Is there a weak entity type? If so, give its name, partial key, and identifying relationship. What constraints do the partial key and the identifying relationship of the weak entity type specify in this diagram? List the names of all relationship types, and specify the (min, max) constraint on the participation of an entity type in a relationship type. Justify your choices. List concisely the user requirements that led to this ER schema designarrow_forwardWhat is the main distinction to be made between a weak entity set and a strong entity set?arrow_forwardWhat is the difference between a feeble entity set and a robust entity set?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 LearningDatabase 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