Question: Consider the EER diagram in Figure 4-33. Lets make the following assumptions: There are 12,500,000 customers. These customers have altogether 40,000,000 card accounts.

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Database Management Systems Questions!

Q:

If the coefficient of static friction between the 50-lb roller and the ground is s = 0.25, determine the maximum force P that can be applied to the handle, so that the roller rolls on the ground...

Q:

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...

Q:

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...

Q:

Consider the EER diagram in Figure 4-33. Lets 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...

Q:

Chapter 8, Question 8-64 in the Textbook. Consider this EER diagram. Let's make the following assumptions: There are 14,000,000 customers. These customers have altogether 50,000,000 card accounts. Of...

Q:

Consider the EER diagram below. 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...

Q:

For the purposes of this question, you should make the following assumptions (except where noted in the questions below): all tables provided D = 0.2 (both for Media General and the media companies...

Q:

* PROBLEM #1 DOWN BELOW * ** PROBLEM #2 ARE THE EXERCISES CIRCLED DOWN BELOW ** Ms. Excel Practice Assignment 5 1. Create a Ms. Excel file using the Project Timeline template and enter the following...

Q:

Ms. Excel Practice Assignment 5 1. Create a Ms. Excel file using the Project Timeline template and enter the following into the template. Change the dates per your judgement. Delete the extra tasks...

Q:

For the below, make the following assumptions (except where noted in the questions below): All tables provided. D = 0.2 (both for Media General and the media companies in Exhibit 12) The market...

Q:

1. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method. 2. What do you estimate the company?s WACC? Please...

Q:

Answer the below questions. (a) Why is credit enhancement required in a securitization? (b) What entity determines the amount of securities needed in a securitization?

Q:

As shown in the sketch, kerosene at 90?F is being drained through 100 feet of 4 inch schedule 80 pipe from a storage tank at 10 psig to a settling tank as shown. The pipe discharge is 20 feet below...

Q:

Question 3 8 ( 1 point ) In the event that a company goes bankrupt, it cannot pay its q , until it has first used assets to pay its q , . a ) bondholders; stockholders b ) stockholders; bondholders c...

Q:

Tucson Tractor Inc. has accumulated the following data over a six-month period: Separate the indirect labor into its fixed and variable components, using the high-lowmethod. Indirect Labor Hours 400...