Homework Session 04

For homework 4 I created a data warehouse based on the “NorthwindLite” database. Using the Project Manager’s Object Worksheet, I was able to construct the data warehouse with the specified data types that were requested. I created the database in SSMS designer and then used the generate scripts feature to generate the necessary SQL code to save as a script file.

Below is the diagram for the DWNorthwindLite database:

Below is the PM's worksheet, I changed the datatype for DimProducts.ProductCategoryName to nvarchar(100) as the example data did not match the proposed type of int.