Task:
Complete a rough design for the Data Warehousing situation described below. In your design, which can be displayed graphically or textually, include 1) contents of fact table – with grain size, and primary key and facts, 2) contents of dimension tables, with primary key, attributes – and what one record corresponds to.
Situation:
The
StateCapital Credit Card Company is developing a data mart centered around the
customer charging portion of its operations. It is interested in facilitating
its management’s ability to get answers that might aid it increase use of
StateCapital Visa Card. This could involve reaching new customers and/or
increasing the use by existing customers.