CramX Logo
RegisterLog in

CIS 499 Database and Data Warehousing Design

This solved assignment explores database and data warehousing design principles.

Miles Rogers
Contributor
5.0
44
10 months ago
Preview (5 of 16 Pages)
100%
Log in to unlock

Page 1

CIS 499 Database and Data Warehousing Design - Page 1 preview image

Loading page ...

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.

Page 2

CIS 499 Database and Data Warehousing Design - Page 2 preview image

Loading page ...

Page 3

CIS 499 Database and Data Warehousing Design - Page 3 preview image

Loading page ...

DDWD2Database and Data Warehousing DesignReference number: 01

Page 4

CIS 499 Database and Data Warehousing Design - Page 4 preview image

Loading page ...

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

Page 5

CIS 499 Database and Data Warehousing Design - Page 5 preview image

Loading page ...

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!

Study Now!

X-Copilot AI
Unlimited Access
Secure Payment
Instant Access
24/7 Support
Document Chat

Document Details

University
Strayer University
Course
CIS 499
Subject
Information Technology

Related Documents

View all
Solved Assignments

CIS 499 Project Deliverable 2: Business Requirements

Solved Assignments

CIS 499 Project Plan Inception

Solved Assignments

CIS 499 Cloud Technology and Analytics

Solved Assignments

CIS 499 Project Deliverable 5: Infrastructure and Security

Solved Assignments

CIS 499 Cloud Technology and Analytics

Solved Assignments

CIS 499 Project Deliverable 3: Database and Data Warehousing Design

Solved Assignments

CIS 499 Business Requirements

Class Notes

DevOps and Its Importance Study Notes

Past Exams

Veeam Certified Engineer VMCE-V12

Past Exams

Modules 1 - 3 Basic Network Connectivity and Commu