NoSQL Includes 5 Long Answers to Discussion Question   A mid-sized financial services company is considering implementing a NoSQL database. From the perspective of an IT Manager in this financial services company, describe how NoSQL databases could be used in the organization. Under what circumstances might it be an appropriate implementation choice for a financial […]

Spatial Database Indexing   Includes 5 Long Answers to Discussion Question   Part of a Database Administrator’s job is to ensure appropriate information retrieval performance of their databases. End users do not and in many cases can’t wait for databases that perform slowly. This is true for many spatial databases. Consider Google Maps and the […]

OLTP and OLAP Organizations use database technology to store data that they collect, analyze, measure, and monitor as they conduct business. Data that is captured during transactional processes, as organizations sell products and services to their customers, is best structured in an OLTP database. Data that is used to analyze trends, key metrics, summary data, […]

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 […]

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 […]

Specialist Database Presentation   Create a 1-page Technical Design Document, which describes the business use of the Learning Team company’s database.   Include scripts and Entity Relationship Diagrams (ERDs).   Submit your document.

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 […]

In the SQL Server 2016 query window, write an XML script that provides an update to one table in the database your team created in Week Two.    Write a XML script that provides a data feed to an external dashboard used by the executives of the company. The Dashboard is not required to be […]

Data Integration in Insurance   Data integration in the insurance industry must be a repeatable process that occurs on an ongoing basis. In this discussion, respond to the following:   Discuss how data integration could be used to improve the insurance industry. For example, car insurance could be improved by installing a GPS system on […]

Data Integration in Retail Retail businesses depend on repeat customers to remain in business. The integration of information that is internal to a department store is challenging to do in a way that optimizes the value of the information. The addition of external data such as tax, credit and economic forecasting data can be a […]