Assignment 3 - Northwind Lite

Solution: Northwind Lite

Owner: Catherine W.

Date: 2016-10-23

Summary

The Northwind Food Company buys and resells various food items to grocery stores. They need to track their orders, customers, product categories, and products with greater accuracy and speed.

The full Northwind Food database has more complete information. This solution is for a stripped-down version of the Northwind database, dubbed “NorthwindLite.”

DWNorthwindLite has three Dimension Tables:

• Categories
• Products
• Customers

A Fact Table:

• FactOrders

and a Fact Dimension Table:

• FactOrderDetails

My Data Warehouse choices

There are two measures in the Order Details table:

• Unit Price
• Quantity

Three foreign keys will be created:

• In the Categories dimension, a Category Key
• In the Products dimension, a Product Key
• In the Customers dimension, a Customer Key