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.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 solutionStudents have asked these similar questions
A clustered bar chart to examine the method of payment by customer type
A chart to examine whether the relationship between net sales and age depends on the marital status of the customer
Customer
Type of Customer
Items
Net Sales
Method of Payment
Gender
Marital Status
Age
1
Regular
1
39.50
Discover
Male
Married
32
2
Promotional
1
102.40
Proprietary Card
Female
Married
36
3
Regular
1
22.50
Proprietary Card
Female
Married
32
4
Promotional
5
100.40
Proprietary Card
Female
Married
28
5
Regular
2
54.00
MasterCard
Female
Married
34
6
Regular
1
44.50
MasterCard
Female
Married
44
7
Promotional
2
78.00
Proprietary Card
Female
Married
30
8
Regular
1
22.50
Visa
Female
Married
40
9
Promotional
2
56.52
Proprietary Card
Female
Married
46
10
Regular
1
44.50
Proprietary Card
Female
Married
36
11
Regular
1
29.50
Proprietary Card
Female
Married
48
12
Promotional
1
31.60
Proprietary Card
Female
Married
40
13
Promotional
9
160.40
Visa
Female
Married
40
14
Promotional
2…
Use the XYZ Apartment Rental Company ERD shown on Figure 1 to answer questions 9 through 12:
According to the XYZ Apartment Rental Company ER diagram, which of the following is true?
Each building must have more than one builder
Each building must have multiple apartments
Each building must have at least 8 apartments
Each building must have more than 2 apartments
Answer: ____
Functional Dependency & Normalization
The table below lists customer/car hire data. Each customer may hire cars from various outlets throughout Glasgow. A car is registered at a particular outlet and can be hired out to a customer on a given date.
carReg
make
model
custNo
custName
hireDate
outletNo
outletLoc
M565 0GD
Tesla
Model S
C100
Smith, J
5/14/2018
101
San Francisco
M565 0GD
Tesla
Model S
C201
Helena, P
5/15/2016
101
San Francisco
N734 TPR
Nissan
Sunny
C100
Smith, J
5/16/2016
101
San Francisco
M134 BRP
Tesla
Model S
C313
Blatt, O
5/14/2018
102
Los Angeles
M134 BRP
Tesla
Model S
C100
Smith, J
5/20/2018
102
Los Angeles
M611 0PQ
Nissan
Sunny
C295
Alice, T
5/20/2018
102
Los Angeles
Fig: Table 1
Identify the functional dependencies represented by the data shown in the table above. State any assumptions you make about the data.
Using…
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
- Data/Database Management system . Consider the ER diagram shown below. Supply the relationship constraints using cardinality ratios and participation constraints on this diagram based on the following assumptions (you may use (min, max) notation if you prefer): An employee may work in up to two departments or may not be assigned to any department. Each department must have one and may have up to three phone numbers. Each department can have anywhere between 1 and 10 employees. Each phone is used by one, and only one, department. Each phone is assigned to at least one, and may be assigned to up to 10 employees. Each employee is assigned at least one, but no more than 6 phones.arrow_forwardfor 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_forwardE4.11 Consider the following relation with sample data.STUDENT INTERNSHIP TABLEStudentID StudentName EmployerID EmployerName PositionID PositionDescription111 Joe A Axel Alarm 1 Sales Intern222 Mike A Axel Alarm 2 IT Help Desk Intern333 Sue B Banex Inc 2 Sales Intern444 Pat B Banex Inc 1 Front Desk Intern555 Bob B Banex Inc 1 Front Desk Intern666 Joe C Calypso Corp 1 Marketing Specialist Intern• The STUDENT INTERNSHIP Table captures the data about student internships.• Each student has a unique Student ID and a Student Name.• Each employer has a unique Employer ID and an Employer Name.• Within each employer, there are positions available.• Each position has a unique Position ID within an employer (two positions from two different employers can have thesame Position ID) and a Position Description.• Each student can work for only one employer and can hold only one position within that employer.• More than one student can work in the same position at the same employer.E4.11a Depict full…arrow_forward
- The following question is based upon the Patient-Treatment relation which records the details of transactions occurring in a medical surgery. 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 Design a relational database for this…arrow_forwardThe following question is based upon the Patient-Treatment relation which records the details of transactions occurring in a medical surgery. 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 Design a relational database for this…arrow_forwardUse the XYZ Apartment Rental Company ERD shown on Figure 1 to answer questions 9 through 12: According to the XYZ Apartment Rental Company ER diagram, which of the following is NOTtrue? A building can have no builders A building can have one builder A building can have two builders A building can have more than two builders Answer: ____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_forwardTAL Distributors is considering changing its business model so that many sales reps can represent one customer and one sales rep can represent many customers. Using this information, convert the following unnormalized relation to fourth normal form.arrow_forwardConsider the sales transactions come from the following tables:1. Product (Product ID (PK), Product Name, Product Category (FK), Product Price)2. Employee (Employee ID (PK), Employee Name, Department Code (FK))3. Department (Department Code (PK), Department Location, Region)4. Customer (Customer ID (PK), Customer Name, Customer Address, City Code (FK))5. City (City Code (PK), City Postcode, City State)6. Sales (Sales ID (PK), Date Sales, Product ID (FK), Employee ID (FK), Customer ID (FK), Quantity,Cost Sales)Draw the dimension modeling for producing the reporting.arrow_forward
- Consider the sales transactions come from the following tables:1. Product (Product ID (PK), Product Name, Product Category (FK), Product Price)2. Employee (Employee ID (PK), Employee Name, Department Code (FK))3. Department (Department Code (PK), Department Location, Region) 4. Customer (Customer ID (PK), Customer Name, Customer Address, City Code (FK))5. City (City Code (PK), City Postcode, City State)6. Sales (Sales ID (PK), Date Sales, Product ID (FK), Employee ID (FK), Customer ID (FK), Quantity, Cost Sales)Draw the dimension modeling for producing the reporting.arrow_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_forwardAlert dont submit AI generated answer. Consider the following relation for product for xyz company. Products Product_ID PaymentDate Salesman Commision_amount Discount_amount With the following dependencies PaymentDate -> Discount_amount Salesman -> Commission_amount Apply normalization until the relationship meets the requirements of 3nf.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