Create New Database Diagram Use SSMS to create new database and name it Zagi_DW 2nd, Use SQL

Fantastic news! We've Found the answer you've been seeking!

Question:

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 Initial Example: Dimensional Model Based on A Single Source ZAGI Retail Company dimensional model for the