B. Create an Enhanced Entity Relationship (EER) diagram for the following case. For each entity propose a primary key. If necessary, add any additional assumption. (8 Marks) A company purchases items from a number of different vendors, who then ship the items to the manufacturer. The items are assembled into products that are sold to customers who order the products. Each customer's order may include one or more lines corresponding to the products appearing in that order. The following points may clarify the problem. a. A supplier may supply many items (by 'may supply' we mean that the supplier may not supply any items). Each item is supplied by any number of suppliers (by 'is supplied' we mean must be supplied by at least one supplier) b. Each item must be used in at least one product, and may be used in many products. Conversely, each product must use one or more items. C. A supplier may send many shipments. On the other hand, each shipment must be sent by exactly one supplier. d. A shipment must include one (or more) items. An item may be included in several shipments. e. A customer may submit any number of orders. However, each order must be submitted by exactly one customer. f. A customer can be government entity or private sector customer g. An order must request one (or more) products. A given product may not be requested on any order, or may be requested in one or more orders. Note: Use the following tools to draw the diagram, duplicate and customize as needed. Entity PK text box A A