Question
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
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), FarmFreshs 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 may be added to the database before any transactions involving them occur.
The owner of FarmFresh has identified the following attributes that she wants included in the model. Do not add or subtract any attributes. You may use the abbreviations for the attributes.
Disbursement clerk ID (DC-ID) | VendorID (VenID) |
Check number (Ck#) | Cash account type (Ctype) |
Check amount (Ck-amt) | Purchase date (Date-pur) |
Vendor name (Vname) | Banks phone number (B-ph) |
Vendor address (Vadd) | Cash account number (Acct#) |
Produce type ID (PT-ID) | Date of check (Date-ck) |
Purchase number (Pur#) | Vendors phone number (V-ph) |
Purchasing agent name (PA-name) | Purchasing agent ID (PA-ID) |
Bank ID (Bank-ID) | Produce type description (Desc) |
Disbursement clerk name (DC-name) | Name of bank (B-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)
Required:
1) Based on the narrative and attribute list above, add multiplicities and attributes to that model to create a complete REA business process model
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started