You have studied the foods and groceries of an online supermarket and proposed a data warehouse architecture for the company. The CEO is pleased with your last report and would like to develop the dimensional model of the data warehouse for evaluating the sales and performing target marketing and also provide a project plan. The CEO was interested in questions like, what is the sales amount and income by different types of products, by sales regions, by time/date (daily, weekly, monthly, day of week, etc), by promotional type, by customer characteristics, etc., which products do the most business, how frequent do existing customers place their orders on the websites, which products do customers w0uld be together with or next, etc., and so on. (Note: you may make assumptions about how the company keeps track of the services time and also how it charges customers for their services, but you have to clearly explain your assumptions in your answer.) A) Identify the dimensions and measures of the data warehouse that are required to satisfy the analysis requested by the business. (Note: you only need bare minimum attributes for dimensions, such as the name and i0 of the entity members.) B) Identify the source tables/columns [in your relational database design) for dimension attributes and measures. Use a table to present the mapping between the source tables/columns and dimension attributes/measu res. C) Design dimension tables and a fact table required to satisfy the analysis requested by the business and draw an ED diagram showing the relationship between the fact table and dimensions. The dimensional modeling should handle the historical changes in the order price and promotion of products. Explain and justify your design and the type of slowly changing dimension being used for handling the required historical changes. D) Explain how the star schema can be used to perform the analysis requested by the business. Use sample SQL statements to illustrate your answer. E) Discuss how to successfully plan and manage the data warehouse project for the online supermarket