DBM 384 Week 4 Data Warehouse Project, Part IV

0 items
DBM 384 Week 4 Data Warehouse Project, Part IV
DBM 384 Week 4 Data Warehouse Project, Part IV
$10.00
  • Description

DBM 384 Week 4 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.