Question: Answer the following questions concerning Figure 2-22: a. Where is a unary relationship, what does it mean, and for what reasons might the cardinalities on
Answer the following questions concerning Figure 2-22:
a. Where is a unary relationship, what does it mean, and for what reasons might the cardinalities on it be different in other organizations?
b. Why is Includes a one-to many relationship, and why might this ever be different in some other organization?
c. Does Includes allow for a product to be represented in the database before it is assigned to a product line (e.g., while the product is in research and development)?
d. If there is a rating of the competency for each skill an employee possesses, where in the data model would we place this rating?
e. What is the meaning of the DOES BUSINESS IN associative entity, and why does each DOES BUSINESS IN instance have to be associated with exactly one TERRITORY and one CUSTOMER?
f. In what way might Pine Valley change the way it does business that would cause the Supplies associative entity to be eliminated and the relationships around it to change?
Step by Step Solution
There are 3 Steps involved in it
Each answerrefers to Figure 222 found in the chapter text a A unary relationship is shown with theEMPLOYEE entity An EMPLOYEE Supervises 0M EMPLOYEEs An EMPLOYEE IsSupervised By 01 EMPLOYEE This relat... View full answer
Get step-by-step solutions from verified subject matter experts