Wholesale Bicycle company Design the data warehouse for a wholesale Bicycle company. The data warehouse has to allow to analyze the company's situation at least with respect to the Bicycle, Customers, Suppliers and Time. Moreover, the company needs to analyze: the Bicycles with respect to its type (racing, mountain, youth. .. ), brands (Giant, Trek, Bianci etc. . ) and sizes (28,26,20 custom ) the customers with respect to their spatial location, by considering at least cities, regions and states The company is interested in learning at least the quantity, income and discount of its sales 1. Identify facts Table, dimensions and measures 2. For each fact: produce the fact schema, design the star or snowflake schema and that can answer the following SQL queries. Make sure you show how the Fact and Dimension tables are joined. a) Find the quantity, the total income and discount with respect to each city, type of bike and the month b) Find the average quantity, income and discount with respect to each country, bike size and year