CIS 499 Database and Data Warehousing Design

Preview (5 of 16 Pages)

100%

Purchase to unlock

Loading page image...

Running head:DDWD1Database and Data Warehousing DesignTony Howell Jr.CIS499February 9, 2013Dr.Richard BurroughsGiven the expansion of PAK-IT,Inc.’s database warehouse and its integration of cloudcomputing and SaaS, how would you design the data warehouse to meet the company’s businessintelligence (BI) goals and data management requirements? In your response, address thefollowing:1.Data Schema Design: Explain the distinction between fact entities and reference entitiesand describe how a star schema will be used to model the fact tables.2.Business Goals: How does the design of the data warehouse align with PAK-IT, Inc.’sgoals, specifically in terms of data consistency, access, and performance?3.Entity-Relationship (E-R) Diagram and Data Flow Diagram (DFD): Discuss how theE-R and DFD diagrams will be used to communicate and test data relationships, as wellas to visualize system processes and data flows.4.Data Warehouse Management: Discuss how PAK-IT, Inc. can ensure high-quality datain the warehouse and the role of a data quality manager.Word Count Requirement: 1200–1500 words.

Loading page image...

DDWD2Database and Data Warehousing DesignReference number: 01

Loading page image...

DDWD3Document ControlChange RecordDateAuthorVersionChange Reference02/9/2013TonyHowellJr.1Original DocumentReviewersNamePositionTony Howell Jr.(CIO) Chief Information Officer

Loading page image...

DDWD4Table of ContentsDocument Control…………………………………………………………………..31.Introduction……………………………………………………………………...52. Purpose…………………………………………………………………………..62.1. Goal…………………………………………………………………………73. Data Schema……………………………………………………………………..94. Entity-Relationship (E-R) Diagram…………………………………………….125. Data Flow Diagram……………………………………………………………..13Entity-Relationship (E-R) Diagram(Microsoft Visio)………………Appendix (A)Data Flow Diagram (DFD)(Micro Visio).…………………………..Appendix(B)

Preview Mode

This document has 16 pages. Sign in to access the full document!

Report

Study Now!

Document Details

Related Documents

CIS 499 Project Deliverable 2: Business Requirements

CIS 499 Cloud Technology and Analytics

CIS 499 Business Requirements

CIS 499 Project Deliverable 5: Infrastructure and Security

CIS 499 Project Deliverable 3: Database and Data Warehousing Design

CIS 499 Project Plan Inception

CIS 499 Cloud Technology and Analytics

DevOps and Its Importance Study Notes

Veeam Certified Engineer VMCE-V12

Modules 1 - 3 Basic Network Connectivity and Commu

Company

Explore

Study Tools