Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Continue with Steam Pro Carpet Cleaning Co., the residential and business carpet cleaning services company. Recall that Steam Pro is introducing a new accounting information

Continue with Steam Pro Carpet Cleaning Co., the residential and business carpet cleaning services company. Recall that Steam Pro 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. All sales for carpet cleaning services are initially handled by a scheduling clerk when a customer service request is received and a date is scheduled for the service. On the scheduled date, a service technician completes the carpet cleaning services. All sales are on account. Customers pay for the carpet cleaning services based on each invoice. Invoices are required to be paid in full 30 days from the date of service. All customer payments are processed by a cash receipts clerk and checks are deposited into the checking account on a daily basis. Using the information provided for Steam Pro Carpet Cleaning Co., prepare an REA Data Model for the Revenue Cycle, including cardinalities using the guidelines and appropriate symbols as described in chapter 7 (17) 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 8 [18]) 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. Use the following format to create the table structures, similar to the approach used in class: Table Name Primary Key Foreign Key(s) Other non-key Attributes . . . . 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

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

Financial Accounting SG

Authors: Meigs

7th Edition

0070422591, 978-0070422599

More Books

Students also viewed these Accounting questions

Question

52. Verify the formula given for theI mage of the .

Answered: 1 week ago

Question

What is American Polity and Governance ?

Answered: 1 week ago

Question

What is Constitution, Political System and Public Policy? In India

Answered: 1 week ago