Using the partially completed REA model, identify the remaining entities and cardinalities. There is an REA Data
Fantastic news! We've Found the answer you've been seeking!
Question:
Using the partially completed REA model, identify the remaining entities and cardinalities. There is an REA Data Modeling Quiz - Part in Canvas where you are to record
Transcribed Image Text:
the members and no record is kept of these requests in the AIS. When making payments, members may pay part or all of their remaining balance. Sometimes a member pays for more than one invoice at a time. A clerk in the cash receipts department processes all cash receipts and makes deposits into one of the company's bank accounts. Almost all cash receipts come from members, but occasionally META receives cash from other sources. When a particular inventory item meets its reorder point, META's computer system automatically generates a purchase order and sends the purchase order to the appropriate supplier the purchase order will reflect the current unit cost for the suppler selected. If multiple items reach their reorder point at the same time, the system will favor suppliers that carry more of the items needed (i.e. if one supplier carries 1 needed item and second supplier carries 2 or more of the items needed, the system will place the order with the second supplier) The actual current unit cost may differ from the standard unit cost as the standard unit cost reflects the average cost across all suppliers of a particular item. There are at least two, but often more, suppliers for each item in inventory to insure availability but of course each order is associated with exactly one supplier Suppliers fill each order individually sometimes, however, they are out of stock of an item. In such cases, they immediately ship what is in stock and then make a second delivery for items that they have to back order. . 1 Once an inventory order is received and the receiving clerk verifies a valid purchase order, the receipt is counted and sent to inventory Occasionally, the receiving clerk must return an entire order or individual items within an order because the shipment arrives damaged (inclement weather conditions during shipping might account for this) or the wrong item was shipped. The receiving clerk is able to determine the need for a return immediately upon receipt; therefore if a purchase is returned it is only associated with one return. When a purchase return is made, META receives a credit memo from the supplier for the returned items. Since META has well established relationships with their suppliers and will place orders with them in the future, no cash is ever received for a purchase return. The cash disbursements clerk pays all supplier invoices individually as they become due after verification of receipt to take advantage of any purchase discounts META also pays employees every two weeks and periodically writes checks to pay off their bank loan. When you discussed how to handle the disbursements with META, they wanted to separately record purchasing cash disbursements (i.e. the cash disbursements for employees and bank loans are not recorded in this cash disbursement table). Note: This database is well-designed thus all agents, resources and typification (category ) tables etc. are added prior to recording events involving them unless otherwise noted in the narrative For simplification purposes, the zip code table is not included = the members and no record is kept of these requests in the AIS. When making payments, members may pay part or all of their remaining balance. Sometimes a member pays for more than one invoice at a time. A clerk in the cash receipts department processes all cash receipts and makes deposits into one of the company's bank accounts. Almost all cash receipts come from members, but occasionally META receives cash from other sources. When a particular inventory item meets its reorder point, META's computer system automatically generates a purchase order and sends the purchase order to the appropriate supplier the purchase order will reflect the current unit cost for the suppler selected. If multiple items reach their reorder point at the same time, the system will favor suppliers that carry more of the items needed (i.e. if one supplier carries 1 needed item and second supplier carries 2 or more of the items needed, the system will place the order with the second supplier) The actual current unit cost may differ from the standard unit cost as the standard unit cost reflects the average cost across all suppliers of a particular item. There are at least two, but often more, suppliers for each item in inventory to insure availability but of course each order is associated with exactly one supplier Suppliers fill each order individually sometimes, however, they are out of stock of an item. In such cases, they immediately ship what is in stock and then make a second delivery for items that they have to back order. . 1 Once an inventory order is received and the receiving clerk verifies a valid purchase order, the receipt is counted and sent to inventory Occasionally, the receiving clerk must return an entire order or individual items within an order because the shipment arrives damaged (inclement weather conditions during shipping might account for this) or the wrong item was shipped. The receiving clerk is able to determine the need for a return immediately upon receipt; therefore if a purchase is returned it is only associated with one return. When a purchase return is made, META receives a credit memo from the supplier for the returned items. Since META has well established relationships with their suppliers and will place orders with them in the future, no cash is ever received for a purchase return. The cash disbursements clerk pays all supplier invoices individually as they become due after verification of receipt to take advantage of any purchase discounts META also pays employees every two weeks and periodically writes checks to pay off their bank loan. When you discussed how to handle the disbursements with META, they wanted to separately record purchasing cash disbursements (i.e. the cash disbursements for employees and bank loans are not recorded in this cash disbursement table). Note: This database is well-designed thus all agents, resources and typification (category ) tables etc. are added prior to recording events involving them unless otherwise noted in the narrative For simplification purposes, the zip code table is not included =
Expert Answer:
Answer rating: 100% (QA)
Based on the given narrative the following entities and their cardinalities can be identified in the ... View the full answer
Related Book For
Accounting Information Systems
ISBN: 978-1133935940
10th edition
Authors: Ulric J. Gelinas, Richard B. Dull
Posted Date:
Students also viewed these accounting questions
-
You are to record transactions completed by Fabulous Furnishings during February of this year. Beginning balances for the accounts listed below have been provided in your Working Papers. This Company...
-
As the bookkeeper of Knight Manufacturing, you are to record the following transactions in the general journal for the month of November: a. Raw materials of $84,000 were issued from the storeroom....
-
As the bookkeeper of Knight Manufacturing, you are to record the following transactions in the general journal for the month of November: a. Raw materials of $72,000 were issued from the storeroom....
-
Suppose that the probability that a mechanic fixes a car correctly is 0.9. Determine the odds against the mechanic fixing a car correctly.
-
The following information pertains to Night Company: Required: Present the operating activities section of the statement of cash flows for Night Company using the indirectmethod. Income Statement...
-
Consider two vector spaces V and W and a linear transformation T: VW, where V has a basis and W has a basis X = {x, x, 3} x = {22} 9 What is the size of the matrix for T relative to the bases X and y
-
Visit the website of Alpha Analytics (www.alpha-analytics.com/home). Briefly describe their data cleaning and validation techniques and how they are applied.
-
Fowle Marketing Research, Inc., bases charges to a client on the assumption that telephone surveys can be completed in a mean time of 15 minutes or less. If a longer mean survey time is necessary, a...
-
Daffy Corporation has two processing departments-Mixing and Cooking. Daffy uses the FIFO method. The following information relates to the Mixing Department: Percentage Complete Mixing Department...
-
(Multiple Choice) 1. In government- wide financial statements, for which activities is depreciation reported? a. Only for governmental activities b. Only for business- type activities c. For both...
-
Explain the Mohr-Columb Theory for the c- soil [your own words].(geotechnical engineering subject)
-
What is meaning of DMAC ? Explain this term Is DMAC hardware or software?
-
Liquid bromine is a dark maroon/brown color. 1,2-dibromo alkanes, on the other hand, are colorless. What would it mean and why, if you added liquid bromine to your final transfer hydrogenation...
-
What is the best thing a programmer can do to improve memory access time? How does it improve memory access time?
-
A memory management system uses TLB (Translation lookaside buffer) to enhance memory access time. If time to access a TLB is x nanoseconds and time to access main memory is y nanoseconds (y >>x),...
-
How many memory accesses are required by a memory instruction?
-
Your client Shobha has been running her business Florals R Us (Florals) for the past four years as a sole proprietorship. This was great because she was able to use the losses from the business...
-
From the choice of simple moving average, exponential smoothing, and linear regression analysis, which forecasting technique would you consider the most accurate? Why? please write it in word...
-
Examine the last column in Table for the following personnel only: security officer, chief information officer (CIO), systems development manager, quality assurance, and systems programming. For each...
-
The following are 10 process failures that indicate weaknesses in control. Process Failures 1. A vendor invoice was posted to the wrong vendor record in the accounts payable master data because the...
-
Following is a list of eight generic control goals from the chapter, followed by eight descriptions of either process failures (i. e., control goals not met) or instances of successful control plans...
-
An atom loses an electron to another atom. Is this an example of a physical or chemical change? (a) chemical change involving the formation of ions (b) physical change involving the formation of ions...
-
Why are ores so valuable? (a) They are sources of naturally occurring gold. (b) Metals can be efficiently extracted from them. (c) They tend to occur in scenic mountainous regions. (d) They hold many...
-
Aluminum ions carry a 3+ charge, and chloride ions carry a 1- charge. What is the chemical formula for the ionic compound aluminum chloride? (a) Al 3 Cl (b) AlCl 3 (c) Al 3 Cl 3 (d) AlCl
Study smarter with the SolutionInn App