Database and Analytics Principles
1
,Table of Contents
Introduction................................................................................................................................4
Task 1: Modelling and implementation......................................................................................5
Task 2: Designing Star Schema................................................................................................20
Task 3 – Data Analysis.............................................................................................................22
Conclusion................................................................................................................................32
References................................................................................................................................33
2
,List of Figures
Figure 1: ERD............................................................................................................................5
Figure 2: DDL command 1........................................................................................................7
Figure 3: DDL command 2........................................................................................................8
Figure 4: DDL command 3........................................................................................................8
Figure 5: DDL command 4........................................................................................................9
Figure 6: DDL command 5........................................................................................................9
Figure 7: Top-down v/s Bottom-up Approach.........................................................................18
3
, Introduction
The below-made report contains the documentation of the three tasks provided. All the
necessary practicals are performed and the screenshots of each of the performed practicals are
pasted in this report. The task number 3 is properly performed using the Tableau software and
in the last part of Task 3, the better analytical tool is discussed.
4
1
,Table of Contents
Introduction................................................................................................................................4
Task 1: Modelling and implementation......................................................................................5
Task 2: Designing Star Schema................................................................................................20
Task 3 – Data Analysis.............................................................................................................22
Conclusion................................................................................................................................32
References................................................................................................................................33
2
,List of Figures
Figure 1: ERD............................................................................................................................5
Figure 2: DDL command 1........................................................................................................7
Figure 3: DDL command 2........................................................................................................8
Figure 4: DDL command 3........................................................................................................8
Figure 5: DDL command 4........................................................................................................9
Figure 6: DDL command 5........................................................................................................9
Figure 7: Top-down v/s Bottom-up Approach.........................................................................18
3
, Introduction
The below-made report contains the documentation of the three tasks provided. All the
necessary practicals are performed and the screenshots of each of the performed practicals are
pasted in this report. The task number 3 is properly performed using the Tableau software and
in the last part of Task 3, the better analytical tool is discussed.
4
