Ask a question from expert

Ask now

Data Warehouse Design: A Case Study of CarHireOZ

14 Pages1757 Words178 Views
   

Added on  2021-06-17

Data Warehouse Design: A Case Study of CarHireOZ

   Added on 2021-06-17

BookmarkShareRelated Documents
Running head: DATA WAREHOUSE DESIGNData Warehouse Design: A Case Study of CarHireOZName of the StudentName of the University
Data Warehouse Design: A Case Study of CarHireOZ_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: A Case Study of CarHireOZ_2
DATA WAREHOUSE DESIGN31. Data Warehouse Bus Matrix:BusinessprocessesDimensionsVEICHLES_TYPESVEICHLES_DETAILSCUSTOMER_INFOMEMBER_INFO_CLASSINTERNET_BOOKINGDRIVER_DETAILSCONTRACTS_DETAILSRETURN_PROCESSDATE_DETAILS_TABLEPROMOTIONAL_ITEMSITEMSPRODUCTS_FOR_SALESTORE_DETAILSMEDIA_ORGANIZATION_DERental andSalesXXXXXXXXXXXXAdvertisement_CommercialsXXXXXXXXThe two business cases here are the Rental and Sales and Adevrtisement_Commercials. The associated facts and dimensions required for the two business processes are given in the above table. The crossed marks are presenting the facts and dimensions associated with the business processes.
Data Warehouse Design: A Case Study of CarHireOZ_3
DATA WAREHOUSE DESIGN42. Star Schema for the Data Marts:2.1 Rental and Sales:Veichle_TypetypeID PKdescription price Veichle_ModelregistrationID PKcolour Manufacturing_YearCustomer_InfocustomerID PKLast_NameFirst_NameOnline_BookingbookingNO PKDriver_DetailsdriverID PKlicenceNO creditcard Contracts_DetailscontractID PKinsurance Mode_Of_PaymentReturn_ProcessreturnprotocolID PKdamage usage Date_InfoDateIDPKDateDayPromotional_ItemsPromotionIDPKTypeCostITEMSItemIDPKTypeNameProducts_For_SaleItemIDPKFKTotalNameCustomerNameRENTAL AND SALESFACT TALERentsInTotalRents_while_Promotingmodel mileage availability photo DOBaddresscity state zip phone condition limitmileage Last_NameFirst_NameBirth_Dateaddresscity state zip phone overduedays totalcost MonthYearQuarterDayOfWeekCostcustomerID PKFKregistrationID FKtypeID FKcustomerID FKdriverID FKcontractID FKreturnprotocolID FKDateIDFKPromotionIDFKItemIDFKSold_ProductsTotal_Earned_RevenueStart_Date_For_RentEnd_Date_For_RentStore_DetailsStoreIDPKNameAddressContactNoFaxNoStoreIDFKOnline_BookingbookingNO FK
Data Warehouse Design: A Case Study of CarHireOZ_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 : Case Study
|16
|1486
|61

Data Warehouse Design Assignment
|18
|1608
|190

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