Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Catering Division of Georgetown Cupcake's sales/collection process begins when the customer places an order through a sales associate. Payment is made at the time

image text in transcribed
The Catering Division of Georgetown Cupcake's sales/collection process begins when the customer places an order through a sales associate. Payment is made at the time of the order. Georgetown Cupcake accepts cash, check, or major credit card. The sales associate enters the customer order in the computer system and prints out three copies of the sales order. One copy of the sales order is provided to the customer, one is sent to the bakery division for production scheduling, and the last copy is filed numerically in a temporary file in the catering division. The temporary file is used to inform the sales team of unfilled orders. After each batch of cupcakes is baked, the bakery staff packages the items to make them ready for delivery. Depending on the variety of items ordered, the order can have multiple batches and, hence, multiple packages. When the full order is complete, a bakery staff person uses the. computer to prepare two copies of a delivery slip and files the sales order in the bakery division's filing cabinet by order number. One copy of the delivery slip is sent to the catering division where a sales associate files the delivery slip and the associated order from the temporary file in the division's filing cabinet by order number. Using the second copy of the delivery slip, the cupcake order is then delivered to the customer by one of the store's delivery staff on the date the customer requested. The delivery person then marks the delivery slip as complete and files it by order number. Returns are not permitted. Required: 1. On the next page, create an REA model of the sales/collection process described above. On your REA model, add the cardinalities that describe the relationships between the operating events only. Because we have limited time, do not add the cardinalities between the events and the resources and agents. 2. In the box below, create any table(s), complete with key attributes, foreign keys, and non-key attributes, needed to record the DELIVER GOODS event. List only the transaction/event table(s). Do not list the master/maintenance tables. You must use proper notation. Points will be deducted for improper notation

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

Auditing And Systems Exam Questions And Explanations

Authors: Irvin N. Gleim, William A Hillison

18th Edition

1581943016, 978-1581943016

More Books

Students also viewed these Accounting questions