Create New Database Diagram

 Use SSMS to create new database and name it Zagi_DW

2nd, Use SQL Coding to create the ZAGI Datawarehouse Tables in Chapter 8's Power Point Slides number 11

• In the Dimension Tables only, CalendarKey, StoreKey, CustomerKey, and ProductKey must be surrogate keys
• Make sure the Data type of each column in Zagi_DW is identical to its source in the operational Database Zagi from your Assignment 1
• Calendar Dimension Columns Data Types must reflect the Data Values available in Chapter 8's Power Point Slides number Slide 13
• In the Sales Fact Table, CalendarKey, StoreKey, CustomerKey, and ProductKey are the composite primary key
• NOTE: DO NOT INSERT any data into Zagi_DW tables

3rd

  

CALENDAR Dimension CalendarKey FullDate Day OfWeek DayOfMonth Month Quarter Year STORE Dimension StoreKey StoreID StoreZip StoreRegionName SALES Fact table CalendarKey (FK) StoreKey (FK) ProductKey (FK) CustomerKey (FK) DollarsSold UnitsSold PRODUCT Dimension ProductKey ProductID ProductName ProductPrice ProductVendorName Product CategoryName CUSTOMER Dimension CustomerKey CustomerID CustomerName CustomerZip