UOP DBM384 Week 1 Assignment Latest

DBM384 Special Purpose Databases

Week 1 Assignment  

Data Warehouse Project, Part I

Includes Option #1 with sql scripts and screenshots in both MS Word and MS Powerpoint

Includes Option #2 with sql scripts and screenshots

Complete the following using Microsoft SQL Server 2016:

Write SQL scripts in Microsoft SQL Server for OLTP that include:

A Data Definition Language (DDL) script creating the four tables with appropriate data types, primary and foreign keys

Data Manipulation Language (DML) scripts that insert a minimum of five records into each table

Select scripts showing the full contents of each table

Write and run a test script for Step Two.

Save a screenshot of the results.

Create a 6-page Technical Design Document that includes the SQL scripts in Microsoft SQL Server, test script, and screenshots.

Compress the Technical Design Document that includes the SQL scripts in Microsoft SQL Server, test script, and screenshots into a ZIP file.

Submit the ZIP file.