Your task is to design a data warehouse for Heathcote Winery Group using multidimensional…
Ace your studies with our custom writing services! We've got your back for top grades and timely submissions, so you can say goodbye to the stress. Trust us to get you there!
Order a Similar Paper Order a Different Paper
Your task is to design a data warehouse for Heathcote Winery Group using multidimensional
Modelling. Your design needs to encompass the following steps:
(i) First construct a Data Warehouse Bus Matrix to identify the company’s business processes
and any likely Data Marts. (10 marks)
(ii) Identify the grain of each star/snowflake schema to design the dimensional model for business
processes you have identified, ensuring your dimensions are conformed, primary and foreign
keys are clearly labelled, and that your attributes are named using verbose textual
descriptions. You also need to provide three rows of the fact table your designed to explain
the meaning of the rows. (40 marks)
(iii) Create the following table with a row for each fact table in your design, indicating the
granularity of each fact and a brief justification for choosing that granularity.
(12 marks).
Attachments:
2020CSE5DWD-A….pdf
Looking for top-notch essay writing services? We've got you covered! Connect with our writing experts today. Placing your order is easy, taking less than 5 minutes. Click below to get started.
Order a Similar Paper Order a Different Paper
