For the E-R diagram provided in Figure 8.24, assume that this company decided to assign each sales

Question:

For the E-R diagram provided in Figure 8.24, assume that this company decided to assign each sales representative to a small, unique set of customers; some customers can now become “members” and receive unique benefits; small manufacturing teams will be formed and each will be assigned to the production of a small, unique set of products; and each purchasing agent will be assigned to a small, unique set of vendors. Make the necessary changes to the E-R diagram and draw and describe the new relationship cardinalities.

Figure 8.24

CUSTOMER Places ORDER BACKORDER Generates Includes PRODUCT COMPONENT VENDOR Comprised_of Supplied_by