REA modeling – ONLY FOR ULTIMATE GEEK

REA modeling – ONLY FOR ULTIMATE GEEK
REA Model Project Summer 2017 Continue with Techarati, Inc., a medium-sized computer retail sales company, and use the following summary of the Revenue cycle to complete the requirements below. Techarati sells computers, purchased from various v endors, to both individual and business customers. All customer orders are handled by a sales represen tative. Once inventory availability is verified, the order is filled and shipped to the cu stomer by a warehouse clerk. If the entire order cannot be filled, the items which are available are shipped to the customer and the remaining items are shipped when they becom e available. Customers mail in their payment based on an individ ual invoice received for each shipment which is due 30 days from the date the cus tomer receives the order. Techarati does not utilize monthly statements. All cash recei pts are processed by a cash receipts clerk and are deposited on a daily basis in the che cking account. Using the information provided for Techarati, Inc. prepare an REA Data Model for the Revenue Cycle, including cardinalities using the guidelines and ap propriate symbols as described in chapter 7 (17) of the textbook. The REA model should be well-formatt ed, 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 LucidCha rt. Use the following format to create the table struct ures, 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 e ach 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 thi s assignment tool on or before the due date. This is an INDIVIDUAL assignment.