Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ACT 388/587 REA Model Project Spring 2023 SAVVYDUDE Continue with SavvyDude, the men's clothing wholesaler in Northeast Ohio. SavvyDude sells men's clothing and accessories to

image text in transcribed

ACT 388/587 REA Model Project Spring 2023 SAVVYDUDE Continue with SavvyDude, the men's clothing wholesaler in Northeast Ohio. SavvyDude sells men's clothing and accessories to retail stores around Northeast Ohio. SavvyDude is introducing a new accounting information system to handle the large volume of sales as a result of its growing business. You are involved in the design of the new system. Use the following summary of the Revenue Cycle to complete the requirements below. When customer orders are received, they are handled by a Sales Clerk. A Warehouse Clerk prepares the order and a Shipping Clerk sends the order to the Customer. If all items are not available to ship, then the items that are available are shipped and the remaining items on the order are shipped at a later date once they are available. All sales are on account and Customers make payments based on a monthly statement. A Cash Receipts Clerk handles the customer cash receipts which are deposited in the checking account on a daily basis. Using the information provided for SavvyDude, prepare an REA Data Model for the Revenue Cycle, including cardinalities using the guidelines and appropriate symbols as described in Chapter 19 of the textbook. The REA model should be well-formatted, easy to follow, and include appropriate cardinality notations. Prepare the REA model using LucidChart (submit as a pdf file). ALSO, create the appropriate table structures (Chapter 20) which would be implemented in a relational database for this model. See the step-by-step guidelines on how to create an REA model in Lucid Chart with cardinalities and how to add the tables in LucidChart. The tables should be included in the same pdf file with the REA model. Ilse the fallnwing format to rreate the tahle structurps cimilarth the annroarh uspd in rlacs. Include at a minimum three non-key attributes for each table and at least 2 non-key attributes for M:N tables. Indicate a primary key for each table, and include foreign keys as necessary. NOTE: Include the table structures in the same file as the REA model...i.e. Submit ONLY one file for this assignment. Submit the file on Blackboard using this assignment tool on or before the due date. This is an INDIVIDUAL assignment

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

Optimization Methods In Finance

Authors: Gérard Cornuéjols, Javier Peña, Reha Tütüncü

2nd Edition

1107056748, 9781107056749

More Books

Students also viewed these Accounting questions

Question

What are the other economic side effects of accidents?

Answered: 1 week ago