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 Universal Recording Company is developing a data mart centered around the customer purchases of digital recordings. It is interested in facilitating its management’s ability to get answers that might aid the company in increasing sales. This could involve reaching new customers and/or increasing the use by existing customers.