Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 3, Problem 3.16RQ
In Figure 3-5b, why must the minimum cardinality next to SUPPLIES from PURCHASED PART be one yet the minimum cardinality next to SUPPLIES from SUPPLIER may be zero?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Let's say we have the attached table :
3. Find the years that company hired more than 5 employees
We have a ternary relationship below:
Job
ID
Employee
Branch
Work
ID
ID
The following rule applies to this system:
One employee only works on one job
One employee only works for one branch
One branch offers many jobs
A job could exist in
many
branches
Many employees are doing same jobs in one branch
Can we decompose the ternary relationship to three binary relationship?
If so, how?
16.What is the compact way to assess the modality for customers buying from salesperson?
A: customers buy from many salespersons
B: customers buy from only one salesperson
C: customers buy from at most one salesperson
D: customers buy from at least one salesperson
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
- Let's say we have the attached table : Find the year in which employees hired with minimum salary more than 1000arrow_forwardUsing the ERD diagram above, explain what would happen if the minimal cardinality was changed to “1” for Raw Materials. (i.e., the relationship becomes "raw materials are used in 1 to many items.”). Please note that the current ER diagram shows the following relationship, “raw materials are used in 0 to many items.”arrow_forwardAn EMPLOYEE has only one JOB_CODE, but a JOB_CODE can be held by many EMPLOYEEs. An EMPLOYEE can participate in many PLANs, and any PLAN can be assigned to many EMPLOYEEs. Note also that the M:N relationship has been broken down into two 1:M relationships for which the BENEFIT table serves as the composite or bridge entity. Question: Create the ERD to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN.arrow_forward
- Do the tables in figure 1entity exhibit entity integrity? Why or why not?arrow_forwardDevelop a diagram that shows the functional dependencies in the SHIPMENT relationarrow_forwardAn EMPLOYEE has only one JOB_CODE, but a JOB_CODE can be held by many EMPLOYEEs. An EMPLOYEE can participate in many PLANs, and any PLAN can be assigned to many EMPLOYEEs. Note also that the M:N relationship has been broken down into two 1:M relationships for which the BENEFIT table serves as the composite or bridge entity. Question: Create the ERD to show the relationship between EMPLOYEE and JOB.arrow_forward
- for the following entities and relationships: Customer, Order, Product, ProductDepartment. One customer can place many orders One order is placed by only one customer. Customers can buy many products in one order. One product can be purchased by many orders. One product belongs to one ProductDeparment. One productdepartment has many products. what is the maximal cardinality between customer and order? what is the maximal cardinality between product and order? what is the maximal cardinality between product and productDepartment?arrow_forwardWhat is the result of the natural join of the following two tables: Airlines and Fleetarrow_forwardThe following question is based upon the Patient-Treatment relation which records the details of transactions occurring in a medical surgery. You may assume the data are representative. PATIENT ID PATIENT NAME PATIENT DOB CONSULT DATE ITEM NUMBER ITEM DESCRIPTION FEE PROVIDER NUMBER DOCTOR NAME 437 REARDON 4/08/1989 19/7/2020 A012 Standard 56 S55768 Leahy 437 REARDON 4/08/1989 20/7/2020 A012 Standard 56 D42433 Meuller 562 BILSTEIN 12/05/2001 20/7/2020 A013 Short 35 S55768 Leahy 361 WILSON 13/08/1997 20/7/2020 A014 Long 75 S55768 Leahy 895 LEMOS 13/10/1952 20/7/2020 A013 Short 35 D42433 Meuller 895 LEMOS 13/10/1952 20/7/2020 A014 Long 75 D42433 Meuller 678 MORTAL 27/02/1969 20/7/2020 A014 Long 75 S55768 Leahy 432 SOAPIER 1/08/1976 21/7/2020 A012 Standard 56 S55768 Leahy You have been asked to design a…arrow_forward
- The following question is based upon the Patient-Treatment relation which records the details of transactions occurring in a medical surgery. You may assume the data are representative. PATIENT ID PATIENT NAME PATIENT DOB CONSULT DATE ITEM NUMBER ITEM DESCRIPTION FEE PROVIDER NUMBER DOCTOR NAME 437 REARDON 4/08/1989 19/7/2020 A012 Standard 56 S55768 Scott 437 REARDON 4/08/1989 20/7/2020 A012 Standard 56 D42433 Mueller 562 BILSTEIN 12/05/2001 20/7/2020 A013 Short 35 S55768 Scott 361 WILSON 13/08/1997 20/7/2020 A014 Long 75 S55768 Scott 895 LEMOS 13/10/1952 20/7/2020 A013 Short 35 D42433 Mueller 895 LEMOS 13/10/1952 20/7/2020 A014 Long 75 D42433 Mueller 678 MORT 27/02/1969 20/7/2020 A014 Long 75 S55768 Scott 432 SOAPIER 1/08/1976 21/7/2020 A012 Standard 56 S55768 Scott You have been asked to design a…arrow_forward8. Professor Hong in the department of Business Analytics at University of Hawaii is evaluating three new textbooks for its introductory management science course, which all business students are required to take. The texts, identified by the authors, are Adams/Jones, Barnes, and Cook/Smith. The committee's selection criteria are topical coverage, readability, cost, and the available supplements. Following are the committee's pairwise comparisons of the three textbooks for each of the four criteria and the committee's pairwise comparisons for the criteria: Coverage Textbook A. C 1 1/2 1/5 2 1 1/3 3 1 Readability Textbook C 1 4. 7 1/4 1 3 C 1/7 1/3 1 Name: Costarrow_forwardDo the tables in figure 1 exhibit entity referential integrity? Why or why not?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
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
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher: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
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY