SQL Server MVP Deep Dives

List of Tables

Chapter 3. Finding functional dependencies

Table 1. Sample data in tabular format

Table 2. Changing the data in the second row to find what attributes depend on OrderNo

Table 3. Another set of changed data, this time to test dependencies for CustomerName

Table 4. Testing functional dependencies for CustomerID

Table 5. Testing functional dependencies for Product

Table 6. Testing functional dependencies for Qty

Table 7. Testing functional dependencies for TotalPrice

Table 8. Testing functional dependencies for OrderTotal

Table 9. Testing functional dependencies for the combination of OrderNo and Product

Table 10. Testing functional dependencies for the combination of CustomerID and OrderTotal

Chapter 5. Gaps and islands

Table ...