Develop an Entity-Relationship model to satisfy all the following requirements described below. Note that you must combine the individual ER models below into one model. 1. The purchasing department of a company issues purchase orders (PO) to its suppliers. 2. A purchasing department may buy from multiple suppliers; a supplier may supply products for multiple purchasing departments. a. Each purchasing department may issue multiple POs. b. Each PO comes from one purchasing department and is for one supplier. c. A supplier may process POs from different purchasing departments. 3. Each PO may reference multiple products; a product may be referenced in multiple POs (through Line Items) a. Each PO has one or more line-items (PO LINE-ITEM). b. Each line item belongs to one PO. c. Each line item is for one product from a supplier. 4. A supplier may supply one or more products, a product is supplied by one supplier. 5. The status of a PO is tracked at the line item level. a. A line item can have multiple statuses. Example of statuses are line item shipped, line item received, line item rejected, line item paid, etc. b. A status can be applicable to multiple line items Instructions 1. Follow the convention of Entity Relationship Modeling in Chan (2013). 2. Read the requirements provided and identify data entities. Remember, an entity is a thing of significance for which information needs to be managed. A good place to start is to identify nouns and determine if they are entities or not. 3. List all entities as specified in the requirements. 4. For each of the requirement described, construct the corresponding ER model. 5. Develop a consolidated model by combining the models developed in Step 4. 6. At every step check accuracy and completeness. a. Are entities and relationships defined represent the requirement accurately? b. Are they complete, i.e., are there missing data entities, are there missing relationships?