UOP DBM384 Week 4 Assignment Data Warehouse Project, Part IV Latest

DBM384 Special Purpose Databases

Week 4 Assignment  

Data Warehouse Project, Part IV

Complete the following using Microsoft SQL Server 2016:

Write SQL scripts that include the following:

A Data Definition Language (DDL) script creating the dimension and fact tables for the credit card database

Data Manipulation Language (DML) scripts that insert records into each table from the data created in the OLTP database created in Week One

Select scripts showing the full contents of each table

Create a star schema using the Database Diagram tool in SQL Server®

Write and run a test script for Step One.

Save a screenshot of the results.

Create a 5-page Technical Design Document that includes the following topics:

The star schema diagram

The SQL DDL scripts

The SQL DML scripts

The test script

The screenshot of the results from running the scripts

Submit your Technical Design Document.