Consider the EER diagram for Pine Valley Furniture shown in Figure 3-12. Figure 5-9 looks at a portion of that EER diagram.
Let's make a few assumptions about the average usage of the system:
• There are 50,000 customers, and of these, 80 percent represent regular accounts and 20 percent represent national accounts.
• Currently, the system stores 2,200,000 orders, although this number is constantly changing.
• Each order has an average of 25 products.
• There are 4,000 products.
• Approximately 1,300 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 data-base. Do you see any opportunities for denormalization?