Continue with Office Supplies PRO, Inc., the small office supplies and equipment business. Use the...

90.2K

Verified Solution

Question

Accounting

image

Continue with Office Supplies PRO, Inc., the small office supplies and equipment business. Use the following summary of the Revenue Cycle to complete the requirements below. All sales at Office Supplies PRO are initially handled by a sales clerk when the customer order is received. The order is prepared by a warehouse clerk and shipped to the customer. If all items for an order are not available, the order is held until it can be filled in full. Therefore, no partial orders are shipped. All sales are on account. Each month customers pay their bill based each invoice for the order. Monthly statements are not used. Some customers are permitted to pay 50% of the invoice with the remaining amount due the following month. All customer receipts are processed by a cash receipts clerk. All checks received from customers are deposited into the checking account. Using the information provided for Office Supplies PRO, Inc., 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. Continue with Office Supplies PRO, Inc., the small office supplies and equipment business. Use the following summary of the Revenue Cycle to complete the requirements below. All sales at Office Supplies PRO are initially handled by a sales clerk when the customer order is received. The order is prepared by a warehouse clerk and shipped to the customer. If all items for an order are not available, the order is held until it can be filled in full. Therefore, no partial orders are shipped. All sales are on account. Each month customers pay their bill based each invoice for the order. Monthly statements are not used. Some customers are permitted to pay 50% of the invoice with the remaining amount due the following month. All customer receipts are processed by a cash receipts clerk. All checks received from customers are deposited into the checking account. Using the information provided for Office Supplies PRO, Inc., 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

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students