Problems and Exercise Questions for Week 4

1. Chapter 7, Problems/Exercises, Questions 5, 16, and 17 (post in the “Week4: Problems and Exercise” DropBox).
5. Study the E-R diagram of Figure 7–20. Based on this E-R diagram, answer the following questions: (5 points) a. How many PROJECTs can an employee work on?
Hint: This is asking about cardinality in relationships as defined on page 203. How many of each entity types are involved with the project and employee entity types?

b. What is the degree of the includes relationship?
Hint: This is asking about degree of relationships as defined on pages 202-203. How many entity types are involved with the relationship with the include relationship? c. Are there any associative entities on this diagram? If so, name them. Hint: Pages 204- 205 describes an associate entity; are they special entities only created when other entities interact with each other? d. How else could the attribute Skill be modeled? Hint: Bottom of page 200 e. Is it possible to attach any attributes to the Includes relationship? Hint: Includes just means on entity type must have another entity type. So this question is asking, we have a project, what are some attributes of a task in the project? The answer is yes! – There are some attributes of tasks that need to be performed as part of the project – just name a few attributes for any possible task. f. Could TASK be modeled as an associative entity?
Hint: Look on page 204-205; how many of each entity do we need for an associative entity?
16. The owner of two pizza parlors located in adjacent towns wants to computerize and integrate sales transactions and inventory management within and between both stores. The point-of-sale component must be very easy to use and flexible enough to accommodate a variety of pricing strategies and coupons. The