Design a high-level conceptual view of a data warehouse

Assignment Help Database Management System

Reference no: EM13757850

An organization has several operational systems: Customer Relationship Management (CRM) for marketing and sales, Enterprise Resource Planning (ERP), and Supply Chain Management (SCM). They also have external customer data. A wide variety of departments utilize this data: sales, marketing, procurement, human resources, R&D, and senior management.

Design a high-level conceptual view of a data warehouse using Microsoft Visio that shows the following:

Integration layers

The data warehouse

Recommended data marts.

Reference no: EM13757850

Questions Cloud

Case analysis - personal navigation devices : Case Analysis - Personal Navigation Devices, Why have Personal Navigation Devices become popular? What technologies are required to facilitate the success of PNDs

Create a simple query for each table that returns : Create a simple query for each table that returns all of the columns and all of the rows for each table. Write a query that displays each part that has been purchased by Huffman Trucking Company

Create a home page using html : To create a simple web page you will need to use a text processor (Notepad) and HTML (hypertext markup language). Do NOT use Word which can create some problems by automatically formatting your work as a web page.

Identify informal fallacies in manipulative appeals : Identify the informal fallacies, assumptions, and biases involved in manipulative appeals and abuses of language. Create written work utilizing the concepts of critical thinking.

Design a high-level conceptual view of a data warehouse : Design a high-level conceptual view of a data warehouse using Microsoft Visio that shows the following: Integration layers and The data warehouse

Samples means and also compute the population mean : Assuming that you sample without replacement, select all possible samples of n = 2 and construct the sampling distribution of the mean. Compare the mean of all the samples means and also compute the population mean. Are they equal? What is the proper..

Different users and implement their permissions using sql : Create at least two different users and implement their permissions using SQL statements. Create a matrix to indicate the permissions (read, insert, delete, modify) you would grant to different users of your database

Internet connections between offices are becoming slow : Campus Travel has recently found that its Internet connections between offices are becoming slow, especially during certain periods of the day. Since all the online traffic is maintained by another company, an increase in capacity requires a form..

Disscuss the concept of dimand schedule : Disscuss the concept of dimand schedule

User Account

All Pages