REA modeling - ONLY FOR ULTIMATE GEEK
hazardalnj
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 vendors, to both individual and
business customers.
All customer orders are handled by a sales representative. Once inventory availability is
verified, the order is filled and shipped to the customer 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 become available.
Customers mail in their payment based on an individual invoice received for each
shipment which is due 30 days from the date the customer receives the order. Techarati
does not utilize monthly statements. All cash receipts are processed by a cash receipts
clerk and are deposited on a daily basis in the checking account.
Using the information provided for Techarati, 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.
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.
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.