FarmFresh Produce Company FarmFresh Produce Company is a produce wholesaler that bus large quantities of produce and sens id sells this produce to grocery stores and restaurants. Four purchasing agents are the cositions of producerea gentis assigned to specific produce Onl i ne terperoduce, however assigned agent is on vacation or is ill, an alternative szent may acquire the absent agent's 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 Farmfresh's three disbursement clerks prepares a check drawn on one of the company's 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, stockholder's, etc.) Farmfresh does not have any petty cash or on-hand cash accounts. FarmFresh does have some savines 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. Prepare a REA business process model with multiplicites/cardinalities for the business process described above. The owner of FarmFresh has identified the following attributes that she wants included in the database. You may use the abbreviations (in bold) in the database design. In addition, document the database structure in the same format as the table that we used in the Access project: Table Name, Primary Key, Foreign Key, Other Attributes There are 8 entities and 10 relationships. Cash and Bank are two separate entities with a relationship between them. Disbursement clerk ID (DCID) Check number (CM) Check amount (Ck-amt) Vendor name (name) Vendor address (Vadd) Produce type ID (PT-ID) Purchase number (Puri) Purchasing agent name (PA-name) BankID (Bank-ID) Disbursement Clerk name (DC-name) Cash disbursement ID (CD-D) Actual Unit Cost of a produce type on a purchase (act-cost) Quantity of each produce type received on a purchase (act-aty) Vendor ID (Veni) Cash account type (Ctype) Purchase date (Date-pur) Bank's phone number(B-ph) Cash account number (Acctt) Date of check (Date-ck) Vendor's phone number (V-ph) Purchasing agent ID (PA-ID) Produce type description (Desc) Name of bank (B-name) FarmFresh Produce Company FarmFresh Produce Company is a produce wholesaler that bus large quantities of produce and sens id sells this produce to grocery stores and restaurants. Four purchasing agents are the cositions of producerea gentis assigned to specific produce Onl i ne terperoduce, however assigned agent is on vacation or is ill, an alternative szent may acquire the absent agent's 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 Farmfresh's three disbursement clerks prepares a check drawn on one of the company's 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, stockholder's, etc.) Farmfresh does not have any petty cash or on-hand cash accounts. FarmFresh does have some savines 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. Prepare a REA business process model with multiplicites/cardinalities for the business process described above. The owner of FarmFresh has identified the following attributes that she wants included in the database. You may use the abbreviations (in bold) in the database design. In addition, document the database structure in the same format as the table that we used in the Access project: Table Name, Primary Key, Foreign Key, Other Attributes There are 8 entities and 10 relationships. Cash and Bank are two separate entities with a relationship between them. Disbursement clerk ID (DCID) Check number (CM) Check amount (Ck-amt) Vendor name (name) Vendor address (Vadd) Produce type ID (PT-ID) Purchase number (Puri) Purchasing agent name (PA-name) BankID (Bank-ID) Disbursement Clerk name (DC-name) Cash disbursement ID (CD-D) Actual Unit Cost of a produce type on a purchase (act-cost) Quantity of each produce type received on a purchase (act-aty) Vendor ID (Veni) Cash account type (Ctype) Purchase date (Date-pur) Bank's phone number(B-ph) Cash account number (Acctt) Date of check (Date-ck) Vendor's phone number (V-ph) Purchasing agent ID (PA-ID) Produce type description (Desc) Name of bank (B-name)