DBM 384 Week 5 Data Warehouse Project Final Project

0 items
DBM 384 Week 5 Data Warehouse Project Final Project
DBM 384 Week 5 Data Warehouse Project Final Project
$10.00
Go to the store page
  • Description

DBM 384 Week 5 Data Warehouse Project Final Project

Finalize the credit card data warehouse by completing the following steps using Microsoft®SQL 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.