Explanation/Reference:
Explanation:
* Scenario
/Missing Data Issues
Customers report that when they make a price change in the Products table, they cannot retrieve the price that the item was sold for in previous orders.
/The current database schema contains a table named OrderDetails. The OrderDetails table contains information about the items sold for each purchase order. OrderDetails stores the product ID, quantities, and discounts applied to each product in a purchase order. The product price is stored in a table named Products.
Reference: http://technet.microsoft.com/en-us/library/aa933055(v=sql.80).aspx