Problem Statement Design the data warehouse for a wholesale sports items company. The data warehouse has to allow to analyse the company's situation at least with respect to the sport items, Customers and Time. Moreover, the company needs to analyse: The sports items with respect to its type (ball, bat, hockey, racket, gloves, shoes, table....), sport_category (cricket, football, basketball, hockey, table tennis.... .) and item_material (plastic, wood, glass, iron..) The sport_items usage with respect to their spatial location, by considering at least cities, regions and states The company is interested in learning at least the a. Quantity of each items b. Total profit the company earned Question No 1 > Identify facts, dimensions and measures? For each fact: a. Produce the attribute tree and fact schema b. Design the snowflake schema and write the following SQL queries i. Find the quantity, the total profit and discount with respect to each city, type of sport_items and the month ii. Find the average quantity, profit and discount with respect to each country, items_material and year iii. Determine the 3 most sold sports items during the month of March Problem Statement Design the data warehouse for a wholesale sports items company. The data warehouse has to allow to analyse the company's situation at least with respect to the sport items, Customers and Time. Moreover, the company needs to analyse: The sports items with respect to its type (ball, bat, hockey, racket, gloves, shoes, table....), sport_category (cricket, football, basketball, hockey, table tennis.... .) and item_material (plastic, wood, glass, iron..) The sport_items usage with respect to their spatial location, by considering at least cities, regions and states The company is interested in learning at least the a. Quantity of each items b. Total profit the company earned Question No 1 > Identify facts, dimensions and measures? For each fact: a. Produce the attribute tree and fact schema b. Design the snowflake schema and write the following SQL queries i. Find the quantity, the total profit and discount with respect to each city, type of sport_items and the month ii. Find the average quantity, profit and discount with respect to each country, items_material and year iii. Determine the 3 most sold sports items during the month of March