UOP DBM384 Week 5 Assignment Data Warehouse Project Final Project Latest

DBM384 Special Purpose Databases

Week 5 Assignment  

Data Warehouse Project Final Project

Finalize the credit card data warehouse by completing the following steps using MicrosoftSQL Server 2016:

Write a Select query against the fact table and one dimension table.

Write a Select query against the fact table and at least two dimension tables, one of which should be the time dimension.

Create a view that queries the fact table and three dimension tables.

Write and run a test script for steps one through three.

Save a screenshot of the results.

Complete the 6-page Technical Design Document that includes the SQL queries created for Week Five, the test script, and screenshots of the results.

Construct a final 15-slide tutorial in Microsoft PowerPoint with speaker notes that addresses the following criteria:

Differentiates between general purpose and specialized databases

Identifies uses of special purpose databases in business

Introduces goals for effective database design

Explains how temporal databases are used in business

Explains how Structured Query Language (SQL) is used with temporal databases

Demonstrates how a temporal database is used in business

Explains how spatial databases are used in business

Explains how SQL is used with spatial databases

Explains the importance of indexing with spatial databases

Demonstrates how a spatial database is used in business

Demonstrates how an eXtensible Markup Language (XML) database is used

Explains how multimedia databases are used in business

Explains how NoSQL databases are being used to store unstructured business data

Explains how mobile databases are used in business

Contrasts Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) databases

Describes data warehouses and data mining

Explains knowledge management

Explains the process of information retrieval

Submit the Technical Design Document and the tutorial presentation.