50.1K

Verified Solution

Link Copied!

Continue with Computer Geeks, Inc. the small computer sales, repair, and consulting business serving both individual and business customers. Computer Geeks, Inc. 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 are initially handled by a sales clerk when a customer order is received. A warehouse clerk then prepares the order and ships it to the customer. If all items on the order are not available, then the available items are shipped and the remaining items are shipped when they become available. All sales are on account. Customers pay for sales based on each invoice. Invoices are required to be paid in full 30 days from the date of sale. 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 Computer Geeks, 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 Computer Geeks, Inc. the small computer sales, repair, and consulting business serving both individual and business customers. Computer Geeks, Inc. 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 are initially handled by a sales clerk when a customer order is received. A warehouse clerk then prepares the order and ships it to the customer. If all items on the order are not available, then the available items are shipped and the remaining items are shipped when they become available. All sales are on account. Customers pay for sales based on each invoice. Invoices are required to be paid in full 30 days from the date of sale. 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 Computer Geeks, 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

See Answer