Data Warehouse Design Assignment

Added on - 17 Jun 2021

  • 18

    Pages

  • 1608

    Words

  • 53

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 4 of 18 pages
Running head:DATA WAREHOUSE DESIGNData Warehouse Design: A Case Study of CarHireOZName of the StudentName of the University
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 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 DESIGN42. Star Schema for the Data Marts:2.1 Rental and Sales:
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document