Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the partially completed REA model, identify the remaining entities and cardinalities. There is an REA Data Modeling Quiz - Part in Canvas where you
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
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 =
Step by Step Solution
★★★★★
3.45 Rating (164 Votes )
There are 3 Steps involved in it
Step: 1
Based on the given narrative the following entities and their cardinalities can be identified in the ...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