Consider the EER diagram in Figure 4-33. Let's make the following assumptions:
• There are 12,500,000 customers.
• These customers have altogether 40,000,000 card accounts. Of these 80 percent are credit card accounts and 20 percent are debit card accounts.
• There are 3,200,000 merchants who accept these cards.
• There are, on average, 30 charges per merchant per day. The range is very large.
• Customers are making, on average, 2,000,000 requests per day to view their account bak ices and transactions.
• Merchants are making, on average, 5,000,000 I quests per day to view the transactions they have submitted to the bank.
a. Based on these assumptions, draw a usage map for this portion of the EER diagram.
b. Create a set of normalized relations based on this EER diagram.
c. What opportunities for denormalization can identify in this case (if any)?