Question: For each dimension table in the diagram you created, identify each column in the fact table that relates the fact table to the dimension table.

  1. For each dimension table in the diagram you created, identify each column in the fact table that relates the fact table to the dimension table. Note: Be sure to include multiple date columns.
  2. What does a row in the factInternetSales table represent to the business? Explain in your own words. For each dimension table in the diagram you created, identify each

Dim Product ProductKey ProductAlternatekey ProductSubcategoryKey Weight Unit MeasureCode SizeUnitMeasureCode English ProductName Spanish ProductName FrenchProductName StandardCost Finished GoodsFlag Color SafetyStockLevel ReorderPoint ListPrice Size SizeRange Weight DaysToManufacture ProductLine Dealer Price Class Style FactInternetSales * OrderDateKey DueDatekey ShipDatekey Customerkey PromotionKey Currencykey Sales Territory Key SalesOrderNumber SalesOrderLine Number Revision Number OrderQuantity UnitPrice ExtendedAmount UnitPrice DiscountPct DiscountAmount Product StandardCost TotalProductCost SalesAmount TaxAmt Freight Carrier Tracking Number CustomerPONumber Order Date DimCustomer Customerkey GeographyKey CustomerAlternatekey Title FirstName MiddleName LastName NameStyle Birth Date MaritalStatus Suffix Gender Email Address YearlyIncome TotalChildren NumberChildrenAtHome English Education Spanish Education FrenchEducation English Occupation Spanish Occupation DimDate * DateKey FullDate Alternatekey DayNumberOfWeek English DayNameOfWeek SpanishDayNameOfWeek FrenchDayNameOfWeek DayNumberOfMonth DayNumberOfYear WeekNumberOfYear English MonthName SpanishMonthName French MonthName

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!