You are to create an appropriate ER diagram for the situation described below. From the diagram you are to produce an initial set of relations. Show your work to normalize the initial relations to a final set (3rd normal form). Clearly indicate your initial set of relations and your final set of relations in your answer. In your explanation, indicate how you went through the normalization process. For the relations, use the format: CS3707 Final Examination Fall 2022 7 Name (key, attr1, attr2,......, foreign key) - any foreign keys use dashed underlines while primary keys use solid underlines Make any needed assumptions (state them) to define identifiers, assess cardinalities, etc. "In an unnamed company, in the purchasing department a purchasing request may be assigned to an expediter. The expeditor follows the purchase request through the entire purchasing process and acts as the sole contact person with the person or unit in the company that is requesting to purchase goods or services. The Purchasing department refers to its fellow employees buying those goods and services as customers. The purchasing process is such that purchase requests from certain special customers must go out for bids to vendors. And the associated Request for Bids for those requests must be approved by the purchasing department. If the purchase is not by a special customer, the product or service can simply be bough from any approved vendor but the purchase request must still be approved by the Purchasing department and the department must issue a Purchase Order. For "special customer" purchases, the Purchasing department can issue a Purchase Order once the winning bid is accepted." CS3707 Final Examination F