Evaluate the star schema design View the star schema in the database diagram dimStore StoreNumber StoreLocation...

  

Transcribed Image Text:

Evaluate the star schema design View the star schema in the database diagram dimStore StoreNumber StoreLocation StoreState Store ManagerFirstName Store ManagerLastName StoreManager StoreType dimSales Department SalesDepartment Sales ManagerFirstName Sales Manager Last Name Sales Manager Department Location dimSKU SKU Description SKUDescription Product Category oc factSaleswithNaturalKeys SKU Sales Department StoreNumber WarehouseNumber Date key Price Quantity GrossSale Discount Discount Pet NetSale dimWarehouse WarehouseNumber WarehouseCity WarehouseState SquareFeet Warehouse ManagerFirstName WarehouseMenagerLestame Warehouse ManagerName dimDate 9 Date Key Calender Date CalendarYear CalendarHalf CalendarHalNumber CalendarYearaNamme CalendarQuarter CalendarQuarter Number CalendarYear QuarterName Calendar Month Calender MonthNumber Calendar MonthName CalendarYearMenthName Calendar MonthStart Calendar Month End Calendar Week Weekday WeekDayName Week DayType DaysinCalendarYear DaysinCalendar Month DaysinCalendar Week WeeksinCalender Month WeeksinCalendarYear B) Evaluate the star schema design Make certain sure you answer these questions: Does the star schema adhere to the format specified in those guidelines? 1. 2. 3. 4. 5. 6. 7. Does it meet the guidelines for naming conventions? Does it meet the guidelines for structure? For key fields and table relationships? What are the dimensions? What measures are in the fact table? Does the fact table have only keys and measures? Are any measures in the dimension tables? Evaluate the star schema design View the star schema in the database diagram dimStore StoreNumber StoreLocation StoreState Store ManagerFirstName Store ManagerLastName StoreManager StoreType dimSales Department SalesDepartment Sales ManagerFirstName Sales Manager Last Name Sales Manager Department Location dimSKU SKU Description SKUDescription Product Category oc factSaleswithNaturalKeys SKU Sales Department StoreNumber WarehouseNumber Date key Price Quantity GrossSale Discount Discount Pet NetSale dimWarehouse WarehouseNumber WarehouseCity WarehouseState SquareFeet Warehouse ManagerFirstName WarehouseMenagerLestame Warehouse ManagerName dimDate 9 Date Key Calender Date CalendarYear CalendarHalf CalendarHalNumber CalendarYearaNamme CalendarQuarter CalendarQuarter Number CalendarYear QuarterName Calendar Month Calender MonthNumber Calendar MonthName CalendarYearMenthName Calendar MonthStart Calendar Month End Calendar Week Weekday WeekDayName Week DayType DaysinCalendarYear DaysinCalendar Month DaysinCalendar Week WeeksinCalender Month WeeksinCalendarYear B) Evaluate the star schema design Make certain sure you answer these questions: Does the star schema adhere to the format specified in those guidelines? 1. 2. 3. 4. 5. 6. 7. Does it meet the guidelines for naming conventions? Does it meet the guidelines for structure? For key fields and table relationships? What are the dimensions? What measures are in the fact table? Does the fact table have only keys and measures? Are any measures in the dimension tables?