Ask a question from expert

Ask now

Data Warehouse Design Assignment

18 Pages1608 Words190 Views
   

Added on  2021-06-18

Data Warehouse Design Assignment

   Added on 2021-06-18

BookmarkShareRelated Documents
Running head: DATA WAREHOUSE DESIGNData Warehouse Design: A Case Study of CarHireOZName of the StudentName of the University
Data Warehouse Design   Assignment_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:.............................................................................................136. Identification of Fields:..............................................................................................................14Bibliography:.................................................................................................................................17
Data Warehouse Design   Assignment_2
DATA WAREHOUSE DESIGN31. Data Warehouse Bus Matrix:BusinessprocessesDimensionsVEHICLE_TYPE_DIMENSIONVEHICLE_DIMENSIONCUSTOMER_DIMENSIONMEMBER_CLASS_DIMENSIONBOOKING_DIMENSIONDRIVER_DIMENSIONCONTRACTS_DIMENSIONRETURN_PROTOCOL_DIMENSIONDATE_DIMENSIONPRODUCT_PROMOTION_DIMENSIONITEM_DIMENSIONSTORES_DIMENSIONMEDIA_COMPANY_DIMENSIONRental and SalesXXXXXXXXXXAdvertisement_CommercialsXXXXXXXX
Data Warehouse Design   Assignment_3
DATA WAREHOUSE DESIGN42. Star Schema for the Data Marts:2.1 Rental and Sales:
Data Warehouse Design   Assignment_4

End of preview

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

Related Documents
Data Warehouse Design and Implementation
|17
|1547
|286

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

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

Data Warehouse Design - PDF
|16
|1079
|172

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

Data Warehouse Design Assignment
|18
|1319
|45