Chapter 6 Management Decision Problem 2
Proposed Data Warehouse Format and Sample Files
Proposed Data Warehouse Format
Product _ID
Product_ Description
Cost_per_ Unit
Units_ Sold
Sales_Region
Division
Customer_ID
The following are sample files from the two systems that would supply the data for the data
warehouse:
Mechanical Parts Division Sales System
Prod_No
Product_ Description
Cost_per_Unit
Units_Sold
Sales_Region
Customer_ID
Corporate Sales System
Product_ID
Product_ Description
Unit_Cost
Units_Sold
Sales_Territory
Division
60231
5.28
900,245
Northeast
Parts
85773
SS assembly unit
12.45
992,111
Midwest
60231
5.28
900,245
N.E.
Anderson
85773
SS assembly unit
12.45
992,111
M.W
Kelly Industries