(Solution) - Consider the EER diagram in Figure 4 33 Let s make the -(2025 Original AI-Free Solution)

Paper Details

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)?