Case Scenario: Design a Logical Database

Tailspin Toys needs reports about outstanding debts. However, some of its customers are its suppliers as well. The company needs to see how much Tailspin Toys owes a partner as well as how much a partner owes Tailspin Toys. Currently, the company has two separate tables: Customers and Suppliers. In addition, its daily maintenance operations take too much time to perform in the off-peak operations window. The organization keeps all invoice history in two tables: Invoices and InvoiceDetails. Tailspin Toys updates its data for the current fiscal year only; all other data is just for analysis.

  1. How can you generate a report that shows the complete picture of operations with a partner?
  2. How can you speed up daily maintenance tasks so that they complete within the available window?
< Back      Next >



© Microsoft. All Rights Reserved.