Chapter 8, Problem 8.67PAE

Problems and Exercises 8-65i5 through 8-68 refer to the large Pine Valley Furniture Company data set provided with the text.

8-67. Consider the EER diagram for Pine Valley Furniture shown in Figure 3-12. Figure 8-15 looks at a portion of that EER diagram.

Figure 8-15 Figure for Problem and Exercise 8-67

Let’s make a few assumptions about the average usage of the system:

1. There are 60,000 customers, and of these, 85 percent represent regular accounts and 15 percent national accounts.
2. Currently, the system stores 2,500,000 orders, although this number is constantly changing.
3. Each order has an average of 30 products.
4. There are 5,000 products.
5. Approximately 1,500 orders are placed per hour.
6. Based on these assumptions, draw a usage map for this portion of the EER diagram.
7. Management would like employees only to use this database Do you see any opportunities for denormalization?