Suppose we have the following star schema. time Dimension table time_key day day of the week...

Transcribed Image Text:

Suppose we have the following star schema. time Dimension table time_key day day of the week month quarter year Branch Dimension table branh_key branch name branch_type sales Fact table time_key item_key branch_key location key dollars_sold units_sold item Dimension table item_key item_name brand type supplier_type Location Dimension table location_key street city province_or_state country (1-a) List all the dimension names and the PK of each dimension. (1-b) What is the PK of the fact table? (1-c) Identify all measures in the fact table (1-d) Identify the dimension hierarchy of Location dimension( (1-e) Identify the dimension hierarchy of Item dimension. Suppose we have the following star schema. time Dimension table time_key day day of the week month quarter year Branch Dimension table branh_key branch name branch_type sales Fact table time_key item_key branch_key location key dollars_sold units_sold item Dimension table item_key item_name brand type supplier_type Location Dimension table location_key street city province_or_state country (1-a) List all the dimension names and the PK of each dimension. (1-b) What is the PK of the fact table? (1-c) Identify all measures in the fact table (1-d) Identify the dimension hierarchy of Location dimension( (1-e) Identify the dimension hierarchy of Item dimension.

Answer rating: 100% (QA)

1a The dimension names are timeitembranch location The primary key of the dimesion tabletime is t... View the full answer