FarmFresh Produce Company is a produce wholesaler that buys large quantities of produce and sells this...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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.) Farm Fresh 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. Prepare a REA business process model with multiplicities/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 (Ck#) Check amount (Ck-amt) Vendor name (Vname) Vendor address (Vadd) Produce type ID (PT-ID) Purchase number (Puri) Purchasing agent name (PA-name) Bank ID (Bank-ID) 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) Vendor ID (VenID) Cash account type (Ctype) Purchase date (Date-pur) Bank's phone number (B-ph) Cash account number (Accta) 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 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 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.) Farm Fresh 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. Prepare a REA business process model with multiplicities/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 (Ck#) Check amount (Ck-amt) Vendor name (Vname) Vendor address (Vadd) Produce type ID (PT-ID) Purchase number (Puri) Purchasing agent name (PA-name) Bank ID (Bank-ID) 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) Vendor ID (VenID) Cash account type (Ctype) Purchase date (Date-pur) Bank's phone number (B-ph) Cash account number (Accta) 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)
Expert Answer:
Answer rating: 100% (QA)
The ER diagram for given problem is shown below C C Prod... View the full answer
Related Book For
Intermediate Accounting principles and analysis
ISBN: 978-0471737933
2nd Edition
Authors: Terry d. Warfield, jerry j. weygandt, Donald e. kieso
Posted Date:
Students also viewed these accounting questions
-
The Schubert Company is a Swiss wholesaler of office supplies. Its unit of currency is the Swiss franc (CHF). Schubert uses a periodic inventory system. Prepare journal entries for the following...
-
Jonathan Brandis Company is a food wholesaler that supplies independent grocery stores in the region. The company has a perpetual inventory system for all of its food products. The FIFO method of...
-
The Hastings Company is a nation-wide wholesaler for small electronic devices. One of its most popular items is a new GPS unit called the WAMI-1000. Hastings has gathered the following information,...
-
Why would you use a prospective overhead rate to accumulate the overhead costs of a job?
-
The following are nine technical accounting terms introduced or emphasized in this chapter: Each of the following statements may (or may not) describe one of these technical terms. For each...
-
Smith Foundry in Columbus, Ohio, uses a predetermined manufacturing overhead rate to allocate overhead to individual jobs based on the machine hours required. At the beginning of the year, the...
-
An article at Mobilize.org reported that the median credit-card balance for undergraduate students was \(\$ 1770\) for those who carried a balance from month to month. A professor at a community...
-
Give as many examples as you can for how International Paper defies the common social criticisms of marketing. What image comes to mind when you hear the words industrial corporation?...
-
Why is it good to review organizational vision and mission. Describe briefly. Explain five basic steps that we take to ensure employees are aligned with organisation strategies? What are the...
-
Bills Boards (BB) is an outdoor advertising company founded by William Longfall. William knows very little accounting so he hired a friend to keep the books. Unfortunately, William did not review his...
-
Draw the temperature profile for a co-current heat exchanger and explain its significance from industrial point of view,
-
Define an AVL-2 tree to be a BST where each node v satisfies balance(v) {-2,-1,0,1,2}. Let N(h) be the minimum number of nodes in an AVL-2 tree of height h. Prove that h = O(lgn) for the case where...
-
According to equity theory, what are the major considerations that couples take into account in evaluating their levels of satisfaction?
-
Consider the following code: int main() { } char names [4] [5] for (int i=0; i <4; i++) = { "Ant", "Bee", "Cat", "Duck"}; printf("%s ", names[i]); 1. Add another string to the array: kangaroo 2. Make...
-
1. The table below contains information about Company X and Company Y. Company Y 42 2 1.48 Current Market Value (million) Number of Shares (million) Earnings per share Company X 70 4 0.75 a)...
-
If f(x) = 6 + Find f'(4). Find f'(x). Find f"(4). 3 X 6 + 22, find f'(x).
-
A company aims to forecast the monthly demand for one of its product families. The table below the demand data for the previous months: Month 1 2 3 4 5 6 7 8 9 10 11 12 Demand 390 373 354 342 345 310...
-
Data 9.2 on page 540 introduces the dataset Cereal, which includes information on the number of grams of fiber in a serving for 30 different breakfast cereals. The cereals come from three different...
-
Union Planters is a Tennessee bank holding company (that is, a corporation that owns banks). (Union Planters is now part of Regions Bank.) Union Planters manages $32 billion in assets, the largest of...
-
Hood Company's condensed financial statements provide the following information. Instructions (a) Determine the following for 2008. (1) Current ratio at December 31. (2) Acid-test ratio at December...
-
Sloan Company traded a used welding machine (cost $9,000, accumulated depreciation $3,000) for office equipment with an estimated fair value of $5,000. Sloan also paid $2,000 cash in the transaction....
-
Smart Manufacturing Systems Pty Ltds accountant recently prepared the following data from the companys accounting records for the year ended 30 June 2019. Factory overhead is applied at the rate of...
-
During the year ended 30 June 2019, Beautiful Bottles Pty Ltd incurred the following costs in connection with its production activities. Required (a) Calculate the relationship between factory...
-
Telecommunications company Toronto Ltd signed a 15year deal to sell capacity on its cable network to a rival company for $200 million. The deal was completed on the last day of Toronto Ltds financial...
Study smarter with the SolutionInn App