This problem provides a list of attributes for a relational database that tracks the purchase of inventory from yendors, and which employee places the order. There are, therefore, four distinct entities of interest: 1) Purchases (event) 2) Inventory (resource) 3) Vendor (agent) 4) Employee (agent) Recognize the existence of the following relationships amongst these entities: A purchase order may be placed for many different inventory items at one time An inventory item may be ordered many times (a mass-produced inventory item) Many purchase orders may be placed with a vendor Each purchase order is to one vendor at most An employee can place many purchase orders Each purchase order is made by one employee at most A table should be created for each of the four entities identified above, Proper relationships should be established with a foreign key between related tables (ie., referential integrity) for efficiently collecting and storing data about purchase orders for inventory from vendors by employees Required: 1) Identify the fifth table that must be created. Explain why. 2) Is the fifth table a resource, event or agent? Explain why. 3) Identify which elements/attributes listed in the problem belong in each of the five tables. As a reminder, some elements/attributes may be in multiple tables because of foreign key relationships and dual (concatenated) primary keys. As a point of clarification, the attribute "extended amount" is referring to quantity purchased of a particular item multiplied by the purchase price of that item. 4) Identify all primary, foreign, and nonkeys/secondary keys in each of the live tables