Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I can begin to construct a REA diagram barely. I understand what REA is. I do not understand how to figure the multiplicities. (I don't

I can begin to construct a REA diagram barely. I understand what REA is. I do not understand how to figure the multiplicities. (I don't seem to understand what questions to ask in order to get the correct multiplicities. please help!

image text in transcribed Moves Unlimited Inc. Movies Unlimited, Inc., a family-owned wholesale company, is located in Fort Myers, Florida and sells DVDs, CD's, books, and magazines at wholesale prices to convenience stores and gas stations that resell them to their customers. Impulse purchases of these products, by customers in convenience stores and gas stations, have fueled tremendous growth for Movies Unlimited. The rapid increase in volume sales has created a need for an informational infrastructure to effectively manage the current growth as well as provide for future expansion opportunities. Movies Unlimited currently uses a manual transaction processing system, as described in the next section. However, the rapid growth has created a need for a more efficient means of data processing and analysis; currently, some information is only available monthly, putting Movies Unlimited at a competitive disadvantage. Thus, Movies Unlimited is currently entertaining bids for a 'systems solution'. The systems development contract will be awarded based on a competitive process that compares prototypes developed by competing firms. Your firm would like to be awarded this contract and so they have selected you, a recent FGCU graduate and accounting technology guru, to develop a systems solution for Movies Unlimited. Volume Sales Procedures Customers (i.e., convenience stores and gas stations) call or fax in their orders for DVDs, videotapes, books, or magazines. Calls are routed to the next available sales clerk, who records the order and faxes are routed to one of two sales clerks, who also record orders in the system. The clerks are responsible for assigning a unique sales order number to each order received. Each order relates to only one customer, however, customers can of course place many orders. Movies Unlimited only keeps track of customers who have placed at least one order. Sales clerks can take many orders, except for newly hired clerks, who are not allowed to take any orders until they have completed the new-hire training seminar. Each order consists of one or more products (i.e., DVDs, videotapes, books, or magazines), and the quantity of each product ordered by the customer. Unfortunately sales clerks do not have the ability to check inventory at the time the order is placed. Thus, some of the items ordered may be 'back-ordered', to be shipped at a later date. After the order has been recorded, a copy of the order is faxed (or emailed) to the customer as confirmation of the order. This order acknowledgment does not constitute an invoice--customers receive an invoice along with the products upon delivery. Products that are ordered before noon are usually shipped to the customer the same business day; products ordered after noon are usually shipped the next business day. A warehouse clerk receives order details, picks the products on each order from the warehouse shelves, and packages them to be shipped to the customer. The employee then creates an invoice and a shipping document indicating the products packaged and the shipper who will actually deliver the products to the customer. Movies Unlimited uses any one of five different shippers. A shipper can be involved with one or more shipments, but each shipment is assigned to only one shipper. A warehouse clerk can have processed many shipments or none at all (e.g., a new warehouse clerk in training). When the products are delivered to the customer, the invoice accompanying the shipment indicates the amount to be paid by the customer. Periodically, the company receives checks in the mail from customers as payment of invoices. The company does not accept partial payments, however occasionally customers will remit a check for more than one invoice. A copy of the invoice(s) (or a notation of the invoice number on the check) accompanies incoming checks. The cashier records the payment, generates a receipt, and mails it to the customer. Customer receipts for combined payments provide a detailed listing of each invoice paid. Each check is deposited into one of three bank accounts operated by the Movies Unlimited, Inc. Finally, sales are not the only source of cash, however, sales account for approximately 95% of the cash receipts. Required Using the template and the data items provided below, construct an REA diagram (entities, relationships, participation cardinalities). The conceptual model should use the model form we use in classEvents in the middle, Resources on the left and Agents on the right. Use the data elements provided below as a guide to your conceptual model (entities), relationships (participation cardinalities), keys and attributes for the volume sales process for Movies Unlimited, Inc. Do not put additional entities in the data model beyond those implied by the data elements list below (i.e. the primary key of each entity must be on the list). Identify the primary key for each entity. ItemNum CustomerName Customer_email WholesaleUnitPrice CustomerPhone ShipperName ShipperAddress BankName ItemTitle Quantity_ordered CashAcctNum EmployeeAddress InvoiceDate SalesOrderDate RetailUnitPrice Receipt# ReceiptDate CustomerFax ShipperID Quantity_shipped JobTitle ShipDate InvType SalesOrderNum CustomerAddress DateOpened SalesOrderTotal EmployeePhone Zipcode AmountBilled City State EmpID SalesOrderTime ShipperPhone AmountReceived CustomerID EmployeeName InvoiceNum \fTable Name Primary Key tblEmployee EmpID tblCustomer CustomerID tblInventory Item# tblCash AcctNum tblSalesOrder SalesOrderNum tblSale InvoiceNum tblCashReceipt Receipt# tblShipper ShipperID tblZipcode ZipCode Item#, Sales Order Num Item#, Invoice Num tblInventory_SalesOrder tblInventory_Sale 9 Tables + 2 Relationship Tables 11 Primary Keys Attributes EmployeeName, EmployeeAddress, EmployeePhone, JobTitle CustomerName, CustomerAddress, CustomerPhone, Cutomer_email, CustomerFax InvType, ItemTitle, RetailUnitPrice, WholesaleUnitPrice Bankname, DateOpened SalesOrderDate, SalesOrderTime SalesOrderTotal InvoiceDate, ShipDate, AmountBilled ReceiptDate, AmountReceived ShipperName, ShipperAddress, ShipperPhone City, State Quantity_ordered Foreign Key zipCode Zipcode EmpID, CustomerID SalesOrderNum, EmpID, CusotmerID, ShipperID, Receipt# EmpID CustomerID AcctNum ZipCode Quantity_shipped, 30 Attrributes 13 Foreign Keys

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting For Decision Making And Control

Authors: Jerold Zimmerman

10th Edition

1259969495, 978-1259969492

More Books

Students also viewed these Accounting questions

Question

Where do you see the organization in 5/10 years?

Answered: 1 week ago