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.
 

Consider the following Physical Data Model (PDM), and then answer the following questions: SalesChannel Channelld ChannelDesc Customer Customerld CustomerDesc CustomerTypeld CityID Material Materialld MaterialDesc Item Itemid ItemDescription ItemColorld Materialld Sizeld ItemSize Sizeld SizeDesc Color * Colorid ColorDescription Stateld 00: City Cityld CityDesc States 9 Stateld StateDesc Orders Orderld - Itemid Customerd Channelld OrderDate Quantity Price CustomerType 9 CustomerTypeld CustomerType... OrderDates V. OrderDate DateTypeld 1/2 DateType DateTypeld DateTypeDesc