1. You should identify dimensions, map dimensions to data sources, and specify dimension hierarchies. For each dimension, you should identify its data sources and attributes in each data source. For hierarchical dimensions, you should indicate levels from broad to narrow.

2. You should specify measures, related data sources and measure aggregation properties

I don't understand what its asking me to do. could you please provide a solution and explanation for these problems?

Thank you!

Pigure 1: ERD for Ratail itness Database Pigure 1: ERD for Ratail itness Database