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
Related Book For
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel
Posted Date: