4. Raffles Bank has 12,500,000 customers. These customers have altogether 40,000,000 card accounts. Of these, 80 percent

[answerhappygod]

4 Raffles Bank Has 12 500 000 Customers These Customers Have Altogether 40 000 000 Card Accounts Of These 80 Percent 1 (110.72 KiB) Viewed 22 times

4. Raffles Bank has 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. Across all applications that use this database, there are on average 625,000 accesses per day of customer data. 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 balances and transactions. Merchants are making, on average, 5,000,000 requests per day to view the transactions they have submitted to the bank. (a) Draw a usage map for Raffles Bank. (12 Marks) (b) Create a set of normalized relations for Raffles Bank. (8 Marks) (c) What opportunities for denormalization can you identify in this case (if any)? (5 Marks)