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
1) The manager of an international company would like to know the quantity sold for each product and foreach store by day, week, month, and year. For each store, the manager would like to know its correspondingcity and country.You have to design a star schema to achieve the goal of this manager.2) If you think that some of your proposed dimension tables in Q1, are not normalized, you have to convertyour star schema into snowflake schema to normalize these dimension tables.
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?
8. 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:
Cost
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
- 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 salespersonarrow_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_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_forward
- What is minimum cardinality?arrow_forwardUse the ER Dlagram shown on Figure 1 to answer question 9: 9. According to the ER diagram on Figure 1, which of the following is true? A) For each employee, we will keep track of either the employee name or the unique employee ID. B) For each department, we will keep track of either the unique department ID or the department location. C) Each employee reports to exactly one department. A department may have many employees reporting to it, but it does not have to have any. D) None of the above. Answer: EmpID EmpName EMPLOYEE Reports To Figure 1 DeptID DEPARTMENT DeptLocationarrow_forwardUniversity AAA has 150 staff which consists of an academic and a non-academic category. Each staff is given an option to select either a PENSION ON 56 YEARS scheme or a PENSION ON 60 YEARS scheme. Display the details of each staff information and the total number of academic staff and non-academic staff that have selected a PENSION ON 56 YEARS scheme and a PENSION ON 60 YEARS scheme. Staffs’ InformationName NoIC Age Category Scheme……. …… …….. …… …..……. …… …….. …… …..……. …… …….. …… …..Report of selected SchemeCategory AcademicPENSION 56 : ....PENSION 60 : ....Report of selected SchemeCategory Non-AcademicPENSION 56 : ....PENSION 60 : .... Figure B (a) analyze the given problem (identify input, process and output).(b) design the given problem (write a pseudocode or draw a flowchart).can I know how to answer question a and b ?arrow_forward
- How can we determine that an entity is in 1NF, 2NF and 3NF?arrow_forwardUniversity AAA has 150 staff which consists of an academic and a non-academic category. Each staff is given an option to select either a PENSION ON 56 YEARS scheme or a PENSION ON 60 YEARS scheme. Display the details of each staff information and the total number of academic staff and non-academic staff that have selected a PENSION ON 56 YEARS scheme and a PENSION ON 60 YEARS scheme. Staffs’ InformationName NoIC Age Category Scheme……. …… …….. …… …..……. …… …….. …… …..……. …… …….. …… …..Report of selected SchemeCategory AcademicPENSION 56 : ....PENSION 60 : ....Report of selected SchemeCategory Non-AcademicPENSION 56 : ....PENSION 60 : .... Figure B (a) analyze the given problem (identify input, process and output).(b) design the given problem (write a pseudocode or draw a flowchart).what is the input,process,output and pseudocode or flowchart for this question?arrow_forwardUniversity AAA has 150 staff which consists of an academic and a non-academic category. Each staff is given an option to select either a PENSION ON 56 YEARS scheme or a PENSION ON 60 YEARS scheme. Display the details of each staff information and the total number of academic staff and non-academic staff that have selected a PENSION ON 56 YEARS scheme and a PENSION ON 60 YEARS scheme. Staffs’ InformationName NoIC Age Category Scheme……. …… …….. …… …..……. …… …….. …… …..……. …… …….. …… …..Report of selected SchemeCategory AcademicPENSION 56 : ....PENSION 60 : ....Report of selected SchemeCategory Non-AcademicPENSION 56 : ....PENSION 60 : .... Figure B (a) analyze the given problem (identify input, process and output).(b) design the given problem (write a pseudocode or draw a flowchart).arrow_forward
- University AAA has 150 staff which consists of an academic and a non-academic category. Each staff is given an option to select either a PENSION ON 56 YEARS scheme or a PENSION ON 60 YEARS scheme. Display the details of each staff information and the total number of academic staff and non-academic staff that have selected a PENSION ON 56 YEARS scheme and a PENSION ON 60 YEARS scheme. Staffs’ InformationName NoIC Age Category Scheme……. …… …….. …… …..……. …… …….. …… …..……. …… …….. …… …..Report of selected SchemeCategory AcademicPENSION 56 : ....PENSION 60 : ....Report of selected SchemeCategory Non-AcademicPENSION 56 : ....PENSION 60 : .... (a) identify input, process and output for above program.(b) write a pseudocode or draw a flowchart for above programarrow_forwardIf 15% of the product has been returned to the company and the company decided to recycle the products to avoid loss, then which of the given is considered as a data? * a.15% of the product has been returned to the company b. the company decided to recycle the products c. the company does not want loss d. 85% of the products are qualityarrow_forwardFor the given business rule, is the explanation for relationship and cardinality correct between PROFESSOR and COURSE below: Business Rule: A university is divided into many schools. Each school has many departments, where each department belongs to one and only one school. Each department should have one or more professors assigned to it, where each professor cannot teach more than two courses. The university wants to record the following data for all professors: professor number and full name. All courses are classified into two categories: Fashion and Technology. Relationship: PROFESSOR “teaches” COURSE Relationship type: 1:M Explanation: Business rules state, “Each course belongs to one and only one professor. Each professor includes one or more courses”. The PROFESSOR entity is on the “one” side of the relationship and the COURSE entity is on the “one or more” side of the relationship. Relationship participation: Mandatory on the “one” side of the…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 Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
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
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