2) (50 pts) You are asked to design the E-R diagram of a system managing the shipments of a shipping company. The system stores customer, employee, and shipment details. Clearly state any assumption you make. Make sure that your design captures the following aspects: a. Information about the customers. Each customer has a customer name, an address, and a unique b. customer identifier Information about the orders. Each customer places an order. An order consists of a number, date of the order, and a unique order identifier Information about the employees. Each employee has a name, a contact number, and a unique employee identifier. Employees are authorized to manage the orders. Information about the shipments. Each shipment has a shipping address, a shipment name, and a unique shipment identifier. The shipments are shipped to the customers, and employees prepare the shipments. Information about the products. Each product has a product name, a price, and a unique product identifier Information about the invoices. Each invoice has a total price, a generated date, and a unique invoice identifier. The invoice is mailed to the customer C. d. c. f. g. Each order should reserve at least one product. h. Every employee can manage one or more orders. i. Note that there are subcomponents for name, and each employee can have multiple phone numbers