Data

Objective(s): 

Using an existing, normalized, transaction database, design a data warehouse.  The data warehouse should be designed using a star-schema, de-normalized structure.  The data warehouse design should also adhere to the best practices discussed in Chapter 3 of your  textbook.

Methodology: 

You will be given a small (5 tables), normalized transaction database.  Using the guidelines in Chapter 3 of your textbook for designing data warehouses, you will create a de-normalized schema for all fields.  You must decide what tables should exist in the resulting data warehouse, how those tables will be related, and what fields will be contained in each table.  Your design should also take into consideration the reporting and analysis that would ultimately be performed against the data warehouse.  (Hint:  You may want to begin with possible reporting requirements).