Problem

Answer the following questions concerning Figure 2-22: a. Where is a unary relationshi...

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

Request Professional Solution

Request Solution!

We need at least 10 more requests to produce the solution.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the solution will be notified once they are available.
Add your Solution
Textbook Solutions and Answers Search