Answered You can hire a professional tutor to get the answer.

QUESTION

Suppose that you are provided with a dataset of anonymous credit card transaction data with the following attributes:

 Suppose that you are provided with a dataset of anonymous credit card transaction data with the following attributes: • credit-card-vendor • credit-card-type • credit-card-cashback-amount • transaction-type-code • transaction-type-code-description • transaction-amount • transaction-date • transaction-country-of-origin • card-holder-name • card-holder-ssn • card-holder-country • card-holder-credit-utilization-after-transaction Consider the transaction-amount and card-holder-credit-utilization-after-transaction attributes to be the values of analytic interest. Define two fact tables, for the transaction-amount and credit-utilization, and at least three dimension tables. Provide both a logical and a physical model. Once this is done, state the base and apex cuboids based on each fact table, as well as three additional cuboids. Specify queries that would create these cuboids based on the physical schema defined in the first part.

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question