Reference no: EM133217291

Your task is to design a data warehouse for Chemist Warehouse using multidimensional Modelling. Your design needs to encompass the following steps:

First construct a Data Warehouse Bus Matrix to identify the company's business processes and any likely Data Marts. (10 marks)

Design the star schema for any Data Marts 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. (40 marks)

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.

Fact table name

Fact granularity

Fact table type

Brief justification

Create the following table with a row for each dimension table in your design, giving a brief justification for choosing that dimension, and indicating any attribute hierarchies that exist within the dimension.

Dimension table name

Brief justification

Attribute hierarchies

Create the following table with a row for each design feature you have used, such as handling of possible null foreign keys, and the inclusion of any fact-less fact tables, degenerate dimensions, role playing dimensions, junk dimensions, outriggers, mini-dimensions, or any other design techniques discussed in the lectures. Provide a brief description of each design feature used (how and where it is used - not the theory behind the concept) and a justification for its use.

Design feature

Brief description

Brief justification

Identify which fields from your facts/dimensions are required to answer each of the business questions listed above.