Book Contents

Book Index

Next Topic

Home

Retail Sales Example Database

The Retail Sales Example Database is based on an entirely fictional retail grocery chain store. It a simple star schema that represents individual line items on POS (Point of Sale) transactions. Each tuple in the fact table represents an item purchased from a store. Each table is described in a separate section.

Linked PNG File Template

 

Table Name

Default Number of Rows

Retail_Sales_Fact

5000000

Product_Dimension

60000

Store_Dimension

250

Promotion_Dimension

1000

In This Chapter

Retail_Sales_Fact

Date_Dimension

Product_Dimension

Promotion_Dimension

Store_Dimension

retail_query_01.sql

retail_query_02.sql

retail_query_03.sql