A. Using the PDM shown above: Design a Star Schema for the following business objectives with the
Question:
A. Using the PDM shown above: Design a Star Schema for the following business objectives with the following grain:
1- "The overall monthly sales revenue achieved at each city by each selling channel'
2- "The annual quantity and price of the sales of each item at each state by each selling channel"
B. The given PDM could be handled as a Snowflake Schema. Can you convert it to a Star Schema? Make sure to keep all levels of details.
Question Two
A. Show at least one example to define the following terms (you can use the designed star schemes from Question ONE to show examples):
1- Factless Fact Table.
2- Conformed Dimension.
3- Surrogate Keys.
4- Federated Data Sources.
5- Slowly Changing Dimension and its Solution Types.
International Marketing And Export Management
ISBN: 9781292016924
8th Edition
Authors: Gerald Albaum , Alexander Josiassen , Edwin Duerr