Objectives
- To create a Data Warehouse conceptual design using Star Schema Modelling
- To document allsteps during the design process
Your Task:
Your task is to design a data warehouse for Qantas Warehouse 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.
(ii) Designthe star schema for any Data Marts you have identified, ensuring your Dimensions are conformed, primary and foreign keys are clearly labelled, and that yourattributes are named using verbose textual descriptions. Provide a sample row of your fact table for each schema.
(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.
|
Fact table name
|
Fact granularity
|
Fact table type
|
Brief justification
|
|
|
|
|
|
(iv) 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
|
|
|
|
|
(v) Create the following table with a row for each design featureyou 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, bridge 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
|
|
|
|
|
(vi) Identify which fields from your facts/dimensions are required to answer each of the business questions listed above.
Attachment:- Business description.rar