Consider the EER diagram for Pine Valley Furniture shown in Figure 3-12. Figure 5-9 look...

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 800,000 orders, although this number is constantly changing.

• Each order has an average of 20 products.

• There are 3,000 products.

• Approximately 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?

b. Most frequently sold product finish in a user-specified month