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:.............................................................................................126. Identification of Fields:..............................................................................................................14Bibliography:.................................................................................................................................16
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 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
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Data Warehouse Design and Implementationlg...
|17
|1547
|286
Data Warehouse Design : Case Studylg...
|16
|1486
|61
Data Warehouse Design Assignmentlg...
|18
|1608
|190
Data Warehouse Design - PDFlg...
|16
|1079
|172
Data Warehouse Design: A Case Study of Chemist Warehouselg...