High-level conceptual view of a data warehouse

Assignment Help Database Management System

Reference no: EM13763986

Conceptual view of a data warehouse

Design a high-level conceptual view of a data warehouse (DW) for Huffman Trucking using Microsoft Visio that shows the following:

a) Integration layers

b) The data warehouse, with a Star Schema showing a Fact table and various dimension tables with all their needed fields and relationships, as covered in the class material.

c) Recommended data marts

Include arrows to show ETL (extract, transform, and load) locations and direction, and paste a screen shot of the above Visio Star schema along with the DW description in a Word document.

Reference no: EM13763986

Questions Cloud

Finding exif data in the photos : This project will have you validating forensic images, processing the data forensically by conducting key word searches and locating graphic files, as well as, finding EXIF data in the photos to determine what tools Chris used to take pictures of ..

Finance industry-based organization : Imagine that you work for a finance industry-based organization. Your organization is looking to submit its database design documentation to an evaluation team in order to meet Sarbanes-Oxley (SOX) compliance.

Federal rules of civil procedure : This is a peer review presentation. Find a case from Kroll Ontrack's website that deal with one of the following the Federal Rules of Civil Procedure, explain why the rule is important in this particular case and create a presentation for peer-rev..

Write an essay on the prophet of the great smoky mountains : Write an essay on The Prophet of the Great Smoky Mountains by Mary Noailles Murfree.

High-level conceptual view of a data warehouse : Design a high-level conceptual view of a data warehouse (DW) for Huffman Trucking using Microsoft Visio that shows the Integration layers.

Deciphering financial statements : Depreciation and Amortization- Effective July 1, 1998, the company increased the depreciable life of certain new generation aircraft types from 20 to 25 years. Owned flight equipment is depreciated on a straight-line basis to a residual value equa..

How do you know when to compromise : What is compromise and how do you know when to compromise and when not to compromise? If you think you should never compromise explain why.

Actions for network devices, topologies, and network attacks : Identify the malicious threat sources to physical security and their corresponding countermeasures

Problems related to travel/transportation : How have societal, political, and/or business systems developed alongside the technical discovery?

User Account

All Pages