Bob insists on using only the highest quality steel

Bob insists on using only the highest quality steel in the manufacturing of his knives. Bob uses a list of vendors that they have a good relationship with.

The steel is purchased when a production supervisor recognizes a need for inventory. The supervisor goes to his terminal and completes a Purchase Order Form online. This is done by selecting the vendor, the inventory item, and the amounts to be ordered. The order can be for one type of steel or for several types. The Purchase Order Form is reviewed by a Purchasing Agent. If it is approved, a Purchase Order Report is prepared, printed, and mailed to the selected vendor.

The goods are received and counted by the Receiving Clerk. The Receiving Clerk enters the date, the PO number, and the Vendor’s Invoice Number in the top portion of the form. In addition, the Clerk must enter the Inventory ID number and the quantity received in the form.

If the order is in agreement with the Purchase Order, it is scheduled for payment. Bob sometimes pays for more than one invoice (receipt of inventory) with each check (cash disbursement). In addition, on occasion they have placed very large orders and have paid for those orders in installments.

Requirements:

Identify the Resources, Events, and Agents.Draw E-R diagrams that illustrate the relationships between these items. In case you need additional assumptions, please make it clear in writing.Identify tables that you would need to create a working database.Create three records for each of the tables you identified in part 3.Create relationships for your various tables.