Question

The Platters By Mail Record Club Case

The Platters by Mail Record Club advertises music records and albums in a variety of magazines and papers. Most orders are submitted by magazine subscribers who complete and send coupons to the Platters by Mail Record Club. All mails arrive at the receptionist's desk. The receptionist sorts and distributes the mails to the appropriate departments.

The order-entry clerk initially checks the inventory data store to identify the availability and price of the ordered items. This clerk also takes orders from customers directly by phone and forwards all fillable order forms to the credit clerk.

When fillable orders are received by the credit clerk, the customer's credit status is checked. The customer data repository includes customer’s name and address, their credit standing, and details of previous payments. Orders are approved and an order-confirmation letter is sent to those customers with good credit standing. The order information includes the customer information (who placed the orders) and the album title, record type, quantity, amount, shipping address, and date of delivery. The credit clerk forwards the approved orders to the warehouse.

The warehouse fills the approved order and updates the inventory availability. A packing slip is sent with the packaged order to the customer, and a shipping notice is sent to the Accounts Receivable Department.

Accounts Receivable bills the customer for the products shipped. This department also maintains the invoice data files, updating them to reflect charges or payments received. Payments are received in the mail and delivered to Accounts Receivable by the receptionist. A payment receipt is sent to the customer for confirmation.

1. Draw Data model in ER notations of the case description

Answer 1