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 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 solution
Students have asked these similar questions
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…
Applying 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…
When we map ER-Diagram with 1: 1 relationship, the foreign key must be in:
Select one:
a.
In the entity that reduce the null values.
b.
In the left entity.
c.
In the right entity.
d.
In any entity.
Chapter 3 Solutions
Modern Database Management (12th Edition)
Ch. 3 - Define each of the following terms: supertype...Ch. 3 - Prob. 3.2RQCh. 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 - Prob. 3.16RQCh. 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 - Prob. 3.30PAECh. 3 - Develop an EER model for the following situation,...Ch. 3 - Draw an EER diagram for the following description...Ch. 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
- Write business rules for the following table to create ER diagram. Just business rules.arrow_forwardAccording to the data model, is it required that every entity instance in the PRODUCT table be associated with an entity instance in the CD table? Why or why not?arrow_forwardAccording to the data model, is it required that table every entity instance in the PRODUCT table be associated with an entity instance in the CD table? Why, or why not?arrow_forward
- The question is in the image below.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_forwardplease answer with proper explanation and step by step solution.arrow_forward
- Given the ER diagram above, answer the following questions: a. Name an entity type that has more than 2 relationships. b. Name one ket attribute and the entity type it belongs to. c. Name one one-to-one relationship and the entity types it relates. d. Name one many-to-many relationship and its entity types. e. Name one relationship attribute. f. What is the cardinality of relationship ‘employs’? g. What is the cardinality of relationship ‘textUsed’? h. Name one weak entity type i. Does it have a partial key? If yes, name it. ii. Name its identifying entity type iii. Name its identifying relationship Question 2 A bank provides services to customers. The banks is identified by its code and has a name and an address. The bank has several branches. A branch is identified by its code that is unique for a given bank. The branch name and address are also stored in the database. Customers deal with the bank through the bank branches. So, a customer belongs to a specific bank branch. Customers…arrow_forwardThe cardinality ratio depends on the real-world meaning of the entity types involved and is defined by the specific application. For the binary relationships below, suggest cardinality ratios based on common-sense meaning of the entity types. Clearly state any assumptions you make. Entity 1 Student Cardinality Ratio Entity 2 Course Item Class Teacher TextBook wwwwwwwwwww Order Instructorarrow_forwardPrepare a Crow’s Foot Entity Relationship Diagram for the application described in the following paragraph. Many-to-Many relationships should be broken into two 1-to-Many relationships using a bridge entity. Label PK attributes and FK when applicable. For each entity, you need to define a primary key. If there is a relationship between two entities make sure you define the corresponding foreign key in the child table. Seneca Sandlot Baseball is a recreational baseball league for Seneca students. The league has different divisions for different skill levels. Each player’s skills are evaluated and the player is assigned to a division. A team is made up of many players from the same division, and a coach. A player may play on only one team in the league. Each division is made up of many teams. A coach may coach teams in more than one division , but can only coach one team in each division. A coach may not play on any team in the league. A season is twelve weeks in length.…arrow_forward
- 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 the relationship in the below Entity Relationship Diagram (ERD) inyour own words.Answer the following questions by referring to the below sample data.arrow_forward2. Consider the ER diagram on the next slide. (i) What is the key of entity set A (ii) What is the key of entity set B (ii) What is the key of entity set C Be sure to explain how you got your answers. b2 b3 a2 a3 b1 a1 a4 b4 A B R1 1 1 c1 c2 c3 c5 c4 N R2arrow_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 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
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY