Andrew deals with several vendors and one of them is Navi Wholesale. Andrew often places orders for chocolate of different flavors at the same time. Each order is placed with one specific vendor. The vendors never consolidate multiple orders into one shipment, and always ship merchandise promptly. Usually, Andrew ’s vendors can fill his entire order in one shipment. Occasionally, however, a vendor may be temporarily out of stock of a particular item. In such cases, the vendor waits until all the items become available and ships the entire order. The vendors do not allow Andrew to make partial payments of invoices or settle several invoices with one payment. Andrew has five bank accounts, and each payment can be made from only one of those accounts. Each transaction is processed by exactly one employee.

1. Identify the resources, events and agents for the accounting system of Jake’s chocolate store. Draw the REA diagram using Microsoft Word (or any other software tools for graphical documentation). Be sure to include all the cardinalities.
2. Prepare a listing of the tables that you would need to create a working database. For each table, specify the primary key, the foreign key (if any), and at least 2 other attributes