0 items
- 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.