Business Analysis

Eliezer Baez

W4

Problems & Exercises

5. Consider the E-R diagram in Figure 7-20. Based on this E-R diagram, answer the following questions:

a. How many EMPLOYEES can work on a project?

According to the diagram figure 7-20 the degree shows many too many which means that there are several projects and many different employees working on them and it all includes the binary relationship.

b. What is the degree of the Used_on relationship?

The degree of the Used_on shows “many” (maximum cardinality) coming from tool and “minimum” (cardinality of zero) to task.

c. Do any associative entities appear in this diagram? If so, name them.

There are no associative entities that are directly show by the associative entity symbol. There’s only many-to-many relationship, works on, which does not need a to be shown as associative entity.

d. How else could the attribute Skill be modeled?

The skill attribute could be modeled as an attributive or a weak entity.

e. What attributes might be attached to the Works_on relationship?

There are no attributes that can be attached to Works_on because it is not a entity. We would represent an attribute by placing the name inside of the rectangle that represent the associated entity.

f. Could TOOL be modeled as an associative entity? Why or why not?

The tool can be modeled as an associative entity because there could be many tools that are needed for the project that the team is working on.

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 easy to use and flexible enough to accommodate a variety of pricing strategies and coupons. The inventory management, which will be linked to the point-of-sale component, must also be easy to use and fast. The systems at each store need to be linked so that sales and inventory levels can be determined instantly for each store and...