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

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

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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Based on the images provided which show the dimensional data model and some sample data from each dimension and the fact table Ill guide you through c... View full answer

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!

solve these question in details Question 3 (1 point) Determine the magnitude of the projection of the force F2 in Newtons along cable AB. Consider F2 = -104 i+130 j+25 k N, a = 4.0 m, and b = 3.0 m....

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Do some amendment and enhance the given research paper: Table of Content Abstract..3 Action Research.4 Research Methodology and Design...5 Literature Review: NoSQL Database7 Proposal.7 Iteration 1..8...

can someone write the queries on SSMS please create these tables with sql query The demonstration recording must start before you open SSMS. Students must demonstrate every step Use SQL Server...

Step 1: Create a new database and name it Wedgewood Step 2: Create a New Query to type the SQL Code to Create all the tables (Do not Insert Data) listed in Slide 8 (DO NOT USE ACCESS) in Chapter 3...

In this assignment, we will create an application which runs on the sample database from the Forta textbook. We will code it in the spirit of three-tier architecture. You will set up the data tier...

Chapter 8 Homework Answer the questions below. In doing this homework, you dont have to use a DBMS. If you didnt create MSU Corporation datanase to do Chapter 7 homework, you can use the table...

Project Specification: 1. Part A: Entity Relationship Diagram 1. Your first task is to study the Case study requirements and gather as much knowledge to list all the main Entities and attributes. 2....

MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and Arizona. MovinOn provides a truck, driver, and one or more moving assistants to move residential...

PLEASE ONLY NEED THE SQL AND THE TABLES FOR THIS WOULD TRULY APPRECIATE UNDERSTANDING THIS! MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and...

A titanium alloy with a modulus of elasticity of 16 106 psi is used to make a 1000-lb part for a manned space vehicle. Determine the weight of a part having the same modulus of elasticity parallel...

Quality Supplier, Inc., accepts cash or credit card payment from customers. During June, Quality provided $170,000 worth of supplies to customers who used Discover cards to pay for their purchases....

Current Attempt in Progress Afirm's ability to pay its obligations as they come due and to met any usloreseen needs for cash is called accounts receivable turnover. liquidity. current ratio. working...

Prerenal causes of acte renal failure include: a. Acute tubular necrosis b. Pyelonephritis O c. Hemorrhage d. Tumors

Elevated CSF protein is found in whereas decreased protein is found in a. CSF leakage, Meningitis b. Hemorrhage, multiple sclerosis c. Hemorrhage, CSF leakage d. Meningitis, hemorrhage

The urinalysis findings in acute poststreptococcal glomerulonephritis include the followings except: a. polyuria b. proteinuria c. hematuria d. pyuria

The metabolic disorder that can be classified as overflow inherited and metabolic disorder is: a. Tyrosinemia b. Melanuria c. Alkaptonuria d. Phenylketonuria

A laboratory technician did not record ollection time of a semen specimen, this will influence the interpretation of: a. appearance b. pH C. viscosity d. volume

May include a simulated division of subsidiary in the accounting system with the purpose of running fictitious transactions through it.

What is a unique identifier of an entity type? Is it possible for there to be more than one unique identifier for an entity type?

What is the difference between an inter-entity class relationship and an intra-entity class relationship?

You must have completed Exercise 9 before beginning this exercise, and thus have used the SQL Data Definition Language to create tables for the three relations DRIVER, TICKET_TYPE, and TICKET. Use...

=+c. For a random sample of 64 grills, calculate the approximate probability that the average number of flaws per grill exceeds 1.

=+60. Figure 5.5 shows how a tree diagram can be used to verify that {A or B} = 5 {A= and B= }. Use a Venn diagram to prove this fact.