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.
1. Using the information provided prepare an REA Data Model for the Revenue Cycle. 2. Create the table s
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am