Your task is to design a data warehouse for Heathcote Winery Group using multidimensionalModelling. Your design needs to encompass the following steps:(i) First construct a Data Warehouse Bus Matrix to identify the company’s business processesand any likely Data Marts. (10 marks)(ii) Identify the grain of each star/snowflake schema to design the dimensional model for businessprocesses you have identified, ensuring your dimensions are conformed, primary and foreignkeys are clearly labelled, and that your attributes are named using verbose textualdescriptions. You also need to provide three rows of the fact table your designed to explainthe meaning of the rows. (40 marks)(iii) Create the following table with a row for each fact table in your design, indicating thegranularity of each fact and a brief justification for choosing that granularity.(12 marks).