Problem 1:

"Describe benefits and drawbacks of a source-driven architecture for gathering of data at a data warehouse, as compared to a destination-driven architecture."

Problem 2: 

"Why is column-oriented storage potentially advantageous in a database system that supports a data warehouse?"

Problem 3: 

"Consider each of the takes and teaches relations as a fact table; they do not have an explicit measure attribute, but assume each table has a measure attribute reg_count whose value is always 1. What would the dimension attributes and dimension tables be in each case. Would the resultant schemas be star schemas or snowflake schemas?"

Problem 4: 

"Consider the star schema from Figure 11.2. Suppose an analyst finds that monthly total sales (sum of the price values of all sales tuples) have decreased, instead of growing, from April 2018 to May 2018. The analyst wishes to check if there are specific item categories, stores, or customer countries that are responsible for the decrease."

Transcribed Image Text:

item_info item_id itemname color size category date_info date month quarter year sales item_id store id customer id date number price store store_id city state country customer customer_id name street city state zipcode country item_info item_id itemname color size category date_info date month quarter year sales item_id store id customer id date number price store store_id city state country customer customer_id name street city state zipcode country