Question - Adam in the AR department files the documents that Barb sent him and updates the AR subsidiary ledger. Mickey in the mail room receives remittance advices and customer checks sent in payment of accounts. He sends the remittance advice to Adam for posting to the AR ledger and sends the checks to Carol, the cash receipts clerk. At the end of the day, she prepares a deposit slip and deposits the checks into the company's bank account, files the bank receipt, and updates the cash receipts journal.
Cash sales to consumer customers are handled in a manner similar to the process described here except that checks or credit card account numbers arc submitted with the original order.
At the end of each week, John, an accounting clerk, reconciles all transactions and posts than to the general ledger.
Required -
a. Prepare the REA model of the sales/collection process.
b. Show the cardinalities for all associations.
c. List the tables, keys, and attributes needed to implement this model in a relational database.