(Solution) - Consider the EER diagram for Pine Valley Furniture shown in -(2025 Original AI-Free Solution)

Paper Details

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?