logo

Data Warehouse Design Assignment

18 Pages1319 Words45 Views
   

Added on  2021-06-16

Data Warehouse Design Assignment

   Added on 2021-06-16

ShareRelated Documents
Running head: DATA WAREHOUSE DESIGNData Warehouse Design of CarHireOZName of the StudentName of the University
Data Warehouse Design Assignment_1
DATA WAREHOUSE DESIGN2Table of ContentsIntroduction:....................................................................................................................................31. Data Warehouse Bus Matrix:.......................................................................................................32. Star Schema for the Data Marts:..................................................................................................42.1 CAR RENT:...............................................................................................................................42.2 Driver Assign:............................................................................................................................52.3 Sell Item:....................................................................................................................................52.4 Invoice Generation:...................................................................................................................62.5 Promotion:.................................................................................................................................73. Fact Table, Granularity and Justification against Granularity:....................................................74. Justification and Attribute Hierarchy of the Dimension Tables:...............................................115. Data Warehouse Design Features:.............................................................................................156. Identification of Fields:..............................................................................................................15Conclusion:....................................................................................................................................17Bibliography:.................................................................................................................................18
Data Warehouse Design Assignment_2
DATA WAREHOUSE DESIGN3Introduction:The data warehouse is the way of storing data in a central location, collected from varioussources, and retrieving data from that storage. The Data Warehouses uses the data miningprocesses for efficient and accurate data retrieving. Warehouses have various data marts and facttables. The fact tables act as the central table that connects the database with the others. 1. Data Warehouse Bus Matrix:BusinessprocessesDimensionsVEHICLE_TYPEVEHICLECUSTOMERMEMBER_CLASSBOOKINGSDRIVERCONTRACTSRETURN_PROTOCOLDATE_TABLE_TABLEPRODUCT_PROMOTIONITEMSSOLD_ITEMSTORESSMEDIA_COMPANYCar RentPPPPPPPPPDrier AssignPPPSell ItemPPPPPInvoiceGenerationPPPPPPPPPromotionPPPPPPPP
Data Warehouse Design Assignment_3
DATA WAREHOUSE DESIGN42. Star Schema for the Data Marts:2.1 CAR RENT:
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 - PDF
|16
|1079
|172

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

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

Data Warehouse Design Assignment
|18
|1608
|190

Data Warehouse Design and Implementation
|17
|1547
|286

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