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.Preview Mode
This document has 16 pages. Sign in to access the full document!