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
EZ Pass organization is developing a data mart centered around the toll
collection portion of its operations. It is interested in facilitating its
management’s ability to get answers that might aid it increase use of EZ Pass.
This could involve reaching new customers and/or increasing the use by existing
customers.