Complete the following using Microsoft SQL Server 2014: Write SQL scripts that includes:

Complete the following using Microsoft® SQL Server® 2014:

1. Write SQL scripts that includes:

• A Data Definition Language (DDL) script creating the dimension and fact tables for the credit card database.
• Data Manipulation Language (DML) scripts that inserts 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®.

2. Write and run a test script for Step One. Save a screenshot of the results.

Create a 6-slide PowerPoint® presentation 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