logo

Data Warehouse Design and Implementation

17 Pages1547 Words286 Views
   

Added on  2021-05-31

Data Warehouse Design and Implementation

   Added on 2021-05-31

ShareRelated Documents
Running head: DATA WAREHOUSE DESIGNData Warehouse Design: A Case Study of CarHireOZName of the StudentName of the University
Data Warehouse Design and Implementation_1
DATA WAREHOUSE DESIGN2Table of Contents1. Data Warehouse Bus Matrix:.......................................................................................................32. Star Schema for the Data Marts:..................................................................................................42.1 Rental and Sales:........................................................................................................................42.2 Advertisement_Commercials:...................................................................................................53. Fact Table, Granularity and Justification against Granularity:....................................................64. Justification and Attribute Hierarchy of the Dimension Tables:.................................................85. Data Warehouse Design Features:.............................................................................................126. Identification of Fields:..............................................................................................................14Bibliography:.................................................................................................................................16
Data Warehouse Design and Implementation_2
DATA WAREHOUSE DESIGN31. Data Warehouse Bus Matrix:BusinessprocessesDimensionsVEHICLE_TYPEVEHICLECUSTOMERMEMBER_CLASSBOOKINGSDRIVERCONTRACTSRETURN_PROTOCOLDATE_TABLE_TABLEPRODUCT_PROMOTIONITEMSITEMS_SALESTORESSMEDIA_COMPANYRental and SalesXXXXXXXXXXXXAdvertisement_CommercialsXXXXXXXX
Data Warehouse Design and Implementation_3
DATA WAREHOUSE DESIGN42. Star Schema for the Data Marts:2.1 Rental and Sales:
Data Warehouse Design and Implementation_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Data Warehouse Design: A Case Study of CarHireOZ
|14
|1757
|178

Data Warehouse Design - PDF
|16
|1079
|172

Data Warehouse Design : Case Study
|16
|1486
|61

Data Warehouse Design Assignment
|18
|1608
|190

Data Warehouse Design Assignment
|18
|1319
|45

Data Warehouse Design: A Case Study of Chemist Warehouse
|19
|2762
|58