Just Say No to Rugs is a manufacturer of high-quality prefinished wood flooring. Their customer base consists

Fantastic news! We've Found the answer you've been seeking!

Question:

Just Say No to Rugs is a manufacturer of high-quality prefinished wood flooring. Their customer base consists of private consumers, building and supply retailers, and construction companies. The company purchases unfinished exotic woods, stains, and finishes from numerous suppliers. The following describes the company’s purchases and cash payments procedures. The inventory control clerk monitors raw material and finished goods inventory levels. When raw materials drop to a predetermined reorder point, the clerk prepares a purchase requisition, which the clerk sends to the purchasing agent, who prepares five copies of a purchase order. Two copies are sent directly to the vendor. One is used to post to the purchases journal and is then placed in an open purchase order file. The AP and the receiving departments also each receive a copy of the purchase orders, which they file temporarily. Each week, the purchasing agent prepares a journal voucher from the purchases journal and sends it to the general ledger department for posting. Upon receiving the raw materials, the receiving department clerk creates four copies of the receiving report. One copy is sent to the raw materials warehouse, and one copy is sent to the AP department. One copy is sent to the inventory control department where it is used to update the inventory records. The final copy is sent to the purchasing department where it is filed. Vendors send their invoices to the AP department, where they are reconciled with the receiving reports and purchase orders. The AP clerk then creates an AP record in the AP subsidiary ledger. On the AP due date, the AP clerk sends the purchase order, receiving report, and invoice to the cash disbursement clerk who prepares a check and sends it to the vendor. After preparation of the checks, the supporting documents are sent back to the AP department. Each week, the AP clerk sends a journal voucher to the general ledger department for posting to the control accounts.

Required:

a. Prepare the REA model to support the purchase and cash payments process.

b. Show the cardinalities for all associations.

c. List the tables, keys, and attributes needed to implement this model in a relational database.