Techarati, Inc., a medium-sized computer retail sales company, and use the following summary of the Revenue cycle to complete the requirements below. 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.

Requirements: 1. Prepare a conceptual business process level REA model for the Revenue cycle for Techarati. Prepare the model by creating a UML class diagram including multiplicities using the format and guidelines from the textbook.

2. Convert the conceptual model into a logical level relational database model by deriving a set of relational tables using the following format: TABLE NAME Primary key (PK) Attribute 1 Attribute2 Attribute (n) Foreign key

Using logical database table structures you created in Part I ( Question01 and 02 already posted today) for Techarati create an Access database and name it using your last name (e.g. Project2_Smith for a project submitted by Joe Smith). Then complete the following steps: 1. Create each table as specified in your logical model in Part I. Name each table using the following naming convention tblTableName (e.g. tblCustomer for the customer table).