Howard Company sells woolen goods and maintains its accounting system using a relational database. To prepare information about sales transactions, the company uses the following tables in its database. The fields that appear in each table are in brackets following the table.
• customers [customer ID, name, shipping address, phone number]
• sales orders [sales order number, customer ID, order date, product ID, order quantity]
• inventory [product ID, product name, quantity on hand, unit price]
• customer shipments [sales order number, shipping date]
• sales invoice [sales invoice number, sales order number, invoice date]
• cash receipts [sales invoice number, cash receipt amount, receipt date]
For each of the following events, identify the tables that would be needed to record the event.
1. Received an order from Jones & Sons for 12 blankets on November 3.
2. Shipped the blankets to Jones & Sons and billed the customer on November 6.
3. Received cash from Jones & Sons for the purchase on December 5.