Howard Company sells woolen goods and maintains its accounting system using a relational database. To prepare information

Question:

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.

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

Step by Step Answer:

Related Book For  book-img-for-question

Financial Accounting Information For Decisions

ISBN: 978-0324672701

6th Edition

Authors: Robert w Ingram, Thomas L Albright

Question Posted: