II DO NOT KNOW WHAT ADDITIONAL INFORMATION YOU NEED. ALL I WANT IS FOR YOU TO USE THE INFORMATION GIVEN TO FILL IN THE BOXES

Source 1 The ZAGI Retail Company Sales Department Database. PRODUCT ProductID Product Name ProductPrice VendorID (FK) CategoryID (FK) REGION RegionID RegionName VENDOR VendorID Vendor Name STORE StoreID Store Zip RegionID (FK) SOLDVIA ProductID (FK) TID (FK) NoOfitems CATEGORY CategoryID Category Name SALESTRANSACTION TID TDate StoreID (FK) Customer ID (FK) CUSTOMER CustomerID Customer Name Customer Zip ZAGI Retail Company Sales DepaChent Analytical Model The data warehouse has to enable an analysis of sales dollar amounts and quantities by the following dimensions: CALENDAR Dimension Calendar Key FullDate DayOfWeek DayOfMonth Month Quarter Year PRODUCT Dimension ProductKey Product ID Product Name Product Price Product VendorName Product CategoryName SALES Fact table Calendarkey (FK) Storekey (FK) ProductKey (FK) Customerkey (FK) Dollars Sold UnitsSold STORE Dimension Store Key StoreID CUSTOMER Dimension Customerkey CustomerID CustomerName Customer Zip StoreZip Store RegionName Source Column(s) Notes Transformation Business Rules productid productid Dimension or Column Source Table(s) Fact dim product productkey product productid product productname productprice productvendorname productcategoryname Region Create SQL ETL: regionname Source Table(s) Source Column(s) Notes Transformation Business Rules identity Dimension or Column Fact dim.customer customerkey customerid customemame customerzip Create SQL ETL: Fact sales calendarkey Each row in Fact Sales is a purchase of a product by a specific customer at a specific store on a specific day. storekey productkey. customerkey dollarssold SALESTRANSACTION customerid storeid tdate SOLDVIA productid tdate noootems unitssold Create SQL ETL: IX English (United States) Focus ES Source 1 The ZAGI Retail Company Sales Department Database. PRODUCT ProductID Product Name ProductPrice VendorID (FK) CategoryID (FK) REGION RegionID RegionName VENDOR VendorID Vendor Name STORE StoreID Store Zip RegionID (FK) SOLDVIA ProductID (FK) TID (FK) NoOfitems CATEGORY CategoryID Category Name SALESTRANSACTION TID TDate StoreID (FK) Customer ID (FK) CUSTOMER CustomerID Customer Name Customer Zip ZAGI Retail Company Sales DepaChent Analytical Model The data warehouse has to enable an analysis of sales dollar amounts and quantities by the following dimensions: CALENDAR Dimension Calendar Key FullDate DayOfWeek DayOfMonth Month Quarter Year PRODUCT Dimension ProductKey Product ID Product Name Product Price Product VendorName Product CategoryName SALES Fact table Calendarkey (FK) Storekey (FK) ProductKey (FK) Customerkey (FK) Dollars Sold UnitsSold STORE Dimension Store Key StoreID CUSTOMER Dimension Customerkey CustomerID CustomerName Customer Zip StoreZip Store RegionName Source Column(s) Notes Transformation Business Rules productid productid Dimension or Column Source Table(s) Fact dim product productkey product productid product productname productprice productvendorname productcategoryname Region Create SQL ETL: regionname Source Table(s) Source Column(s) Notes Transformation Business Rules identity Dimension or Column Fact dim.customer customerkey customerid customemame customerzip Create SQL ETL: Fact sales calendarkey Each row in Fact Sales is a purchase of a product by a specific customer at a specific store on a specific day. storekey productkey. customerkey dollarssold SALESTRANSACTION customerid storeid tdate SOLDVIA productid tdate noootems unitssold Create SQL ETL: IX English (United States) Focus ES