1. Using the information provided prepare an REA Data Model for the Revenue Cycle. 2. Create the table structures, Table Name, Primary Key, Foreign Key(s) ,Other non-key Attributes . . . .

All repair services appointments are handled by a service clerk when a customer requests repair services. A mechanic completes the auto repair services at the appointed time. All repair services require at least 50% payment at the time the services are complete and the remainder is required to be paid in 30 days.

Customers pay 50% at the time the repairs are complete and the remainder is paid in full in 30 days based on an invoice. All customer receipts are processed by a cash receipts clerk and are deposited into the checking account on a daily basis.