The Model For Sale Business Process Of Healthy Food Company Essay

779 Words Feb 8th, 2015 4 Pages
The schema above is the dimensional model for sale business process of Healthy Food Company. This company sales several types of healthy food on the internet. The company has two business requirements. First, the company would like to analyze daily quantity-on-hand inventory levels by products. In order to meet this requirement, I designed the dimensional model by using the periodic snapshot approach so the company could see the quantity-on-hand of each product at the end of the day. This design has two dimension tables and one fact table: DimDate, DimProducts, and InventoryFact. There is no need to have the DimStores in the schema because the company has only one store at this moment.
Second, the company also would like to analyze the audit trail of shipments of products to customers. This process is involved with the customer the products is being shipped to, what product and in what quantity and different shipping categories (type and container). In order to meet this requirement, I designed the dimensional model by using junk dimension technique. Since the shipment has two categories, I combined both categories into one dimension table, instead of having one dimension table for category of type and another dimension table for category of container. This junk dimension technique helps reducing the complexity of the schema and the number of joins in SQL statements
The design is involved with four dimension tables and one fact table: DimDate, DimProducts, DimShipments,…

Related Documents