FarmFresh Produce Company FarmFresh Produce Compan produce to grocery stores and ny a produce wholesaler that buys large quantities of produce ngents arrange the acquisitions thiws of produce; agent is assigned to s pecific produce types. Only one agent is assigned to each nem of produtce: o with any acquisition. Agents can acquire several types of produce t an rnt is on vacation or is ifl, an alternative agent may acquire the absent agent's produce ty one agent is involved A produce item may on any single purchase. produce types are available from which vendors. y be available from more than one vendor, and FarmFresh wants to be able to t 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 ditferent. banks, and the same check numbers could be used by the different checking accounts. Besides checks wrnsen 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. FarmF u resh does have some e savings accounts and certificates of deposit, held at some af the account same banks at which FarmFresh has checking accounts Employees, vendors, inventory items, cash accounts, and banks can be added to the database belore any transactions involving them occur Prepare a REA business process model with multiplicities/cardinalitie The owner of FarmFresh has identified the following attributes tha s for the business process described above t she wants included in the database. You addition, document the database structure in the may use the abbreviations (in bold) in the database design. In same format as the table that we used in the Access project: Table Name, Primary Key, For Attributes eign Key, Other There are & entities and 10 relationships. Ca nd ank ar two sepalondio betwren them. Vendor ID (VenlD) Cash account type (Ctype) Purchase date (Date-pur) Bank's phone number (8-ph) Cash account number (AcctH) Date of check (Date-ck) Vendor's phone number (V-ph) Purchasing agent ID (PA-ID) Produce type description (Desc) Disbursement clerk ID (DCID) Check number (Ck#) Check amount (Ck-amt) Vendor name (Vname) Vendor address (Vadd) Produce type ID (PT Purchase number (Purt) Purchasing agent name (PA-name) Bank ID (Bank-ID) Name of bank (B-name) Disbursement Clerk name (DC-name) Cash disbursement ID (CD-ID) Actual Unit Cost of a produce type on a purchase (act-cost) Quantity of each produce type received on a purchase (act-qty) o Jendo FarmFresh Produce Company FarmFresh Produce Compan produce to grocery stores and ny a produce wholesaler that buys large quantities of produce ngents arrange the acquisitions thiws of produce; agent is assigned to s pecific produce types. Only one agent is assigned to each nem of produtce: o with any acquisition. Agents can acquire several types of produce t an rnt is on vacation or is ifl, an alternative agent may acquire the absent agent's produce ty one agent is involved A produce item may on any single purchase. produce types are available from which vendors. y be available from more than one vendor, and FarmFresh wants to be able to t 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 ditferent. banks, and the same check numbers could be used by the different checking accounts. Besides checks wrnsen 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. FarmF u resh does have some e savings accounts and certificates of deposit, held at some af the account same banks at which FarmFresh has checking accounts Employees, vendors, inventory items, cash accounts, and banks can be added to the database belore any transactions involving them occur Prepare a REA business process model with multiplicities/cardinalitie The owner of FarmFresh has identified the following attributes tha s for the business process described above t she wants included in the database. You addition, document the database structure in the may use the abbreviations (in bold) in the database design. In same format as the table that we used in the Access project: Table Name, Primary Key, For Attributes eign Key, Other There are & entities and 10 relationships. Ca nd ank ar two sepalondio betwren them. Vendor ID (VenlD) Cash account type (Ctype) Purchase date (Date-pur) Bank's phone number (8-ph) Cash account number (AcctH) Date of check (Date-ck) Vendor's phone number (V-ph) Purchasing agent ID (PA-ID) Produce type description (Desc) Disbursement clerk ID (DCID) Check number (Ck#) Check amount (Ck-amt) Vendor name (Vname) Vendor address (Vadd) Produce type ID (PT Purchase number (Purt) Purchasing agent name (PA-name) Bank ID (Bank-ID) Name of bank (B-name) Disbursement Clerk name (DC-name) Cash disbursement ID (CD-ID) Actual Unit Cost of a produce type on a purchase (act-cost) Quantity of each produce type received on a purchase (act-qty) o Jendo