Exercise $41)$ The manager of an international company would like to know the quantity sold for each product and for each store by day, week, month, and year. For each store, the manager would like to know its corresponding city and country. You have to design a star schema to achieve the goal of this manager. $2)$ If you think that some of your proposed dimension tables in Q$1,$ are not normalized, you have to convert your star schema into snowflake schema to normalize these dimension tables.