FarmFresh Produce Company

FarmFresh Produce Company is a produce wholesaler that buys large quantities of produce and sells this produce to grocery stores and restaurants. Four purchasing agents arrange the acquisitions of produce; each agent is assigned to specific produce types. Only one agent is assigned to each item of produce; however, if an assigned agent is on vacation or is ill, an alternative agent may acquire the absent agents produce types. Only one agent is involved with any acquisition. Agents can acquire several types of produce on any single purchase. A produce item may be available from more than one vendor, and FarmFresh wants to be able to track which produce types are available from which vendors.

One of FarmFreshs three disbursement clerks prepares a check drawn on one of the companys checking accounts to pay vendors for purchases. One check is prepared for all purchases made from a vendor during the previous week. Partial payments are never made. The company has checking accounts at several different banks, and the same check numbers could be used by the different checking accounts. Besides checks written to vendors (which constitute only approximately 20% of all checks written), FarmFresh disbursement clerks also issue checks to employees, lenders, stockholders, etc.) FarmFresh does not have any petty cash or on-hand cash accounts. FarmFresh does have some savings accounts and certificates of deposit, held at some of the same banks at which FarmFresh has checking accounts Employees, vendors, inventory items, cash accounts, and banks can be added to the database before any transactions involving them occur.

HELP: Please create a REA diagram with multiplicities. The diagram includes 8 entities and 10 relationships. Cash and Bank are two separate entities with a relationship between them. In addition, document the database structure in the same format as the table that used in the Access project: Table Name, Primary Key, Foreign Key, Other Attributes.

THIS IS A DIFFERENT QUESTION THAN WHAT HAS BEEN POSTED BEFORE.

Disbursement clerk ID	Quantity of each produce type received on a purchase
Check number	Vendor ID
Check amount	Cash account type
Vendor name	Purchase date
Vendor address	Banks phone number
Produce type ID	Cash account number
Purchase number	Date of check
Purchasing agent name	Vendors phone number
Bank ID	Purchasing agent ID
Disbursement Clerk name	Produce type description
Cash disbursement ID	Name of bank
Actual Unit Cost of a produce type on a purchase