Consider the EER diagram for Pine Valley Furniture shown in Figure 3-12. Figure 8-15 looks at a portion of that EER diagram.
Let’s make a few assumptions about the average usage of the system:
a. There are 60,000 customers, and of these, 85 percent represent regular accounts and 15 percent national accounts.
b. Currently, the system stores 2,500,000 orders, although this number is constantly changing.
c. Each order has an average of 30 products.
d. There are 5,000 products.
e. Approximately 1,500 orders are placed per hour.
a. Based on these assumptions, draw a usage map for this portion of the EER diagram.
b. Management would like employees only to use this database. Do you see any opportunities for denormalization?