Skip to content
Solved Assignments

CIS 499 Database and Data Warehousing Design

This solved assignment explores database and data warehousing design principles.

Preview 5 of 16 pages

See the first 5 pages exactly as they appear in the document.

  1. Page 1
    Read page 1 as text

    Running head: DDWD 1 Database and Data Warehousing Design Tony Howell Jr. CIS4 99 February 9, 2013 Dr. Richard Burroughs Given the expansion of PAK - IT, Inc.’s database warehouse and its integration of cloud computing and SaaS, how would you design the data warehouse to meet the company’s business intelligence (BI) goals and data management requirements? In your response, address the following: 1. Data Schema Design : Explain the distinction between fact entities and reference entities and 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.’s goals, specifically in terms of data consistency, access, and performance? 3. Entity - Relationship (E - R) Diagram and Data Flow Diagram (DFD) : Discuss how the E - R and DFD diagrams will be used to communicate and test data relationships, as well as to visualize system processes and data flows. 4. Data Warehouse Management : Discuss how PAK - IT, Inc. can ensure high - quality data in the warehouse and the role of a data quality manager. Word Count Requirement: 1200 – 1500 words.

  2. Page 2
  3. Page 3
    Read page 3 as text

    DDWD 2 Database and Data Warehousing Design Reference number: 01

  4. Page 4
    Read page 4 as text

    DDWD 3 Document Control Change Record Date Author Version Change Reference 02 / 9 /2013 Tony Howell Jr. 1 Original Document Reviewers Name Position Tony Howell Jr. (CIO) Chief Information Officer

  5. Page 5
    Read page 5 as text

    DDWD 4 Table of Contents Document Control…………………………………………………………………..3 1. Introduction…………………………………………………………………… ...5 2. Purpose…………………………………………………………………………..6 2.1. Goal…………………………………………………………………………7 3. Data Schema……………………………………………………………………..9 4 . Entity - Relationship (E - R) Diagram……………………………………………. 12 5. Data Flow Diagram…………………………………………………………… ..13 Entity - Relationship (E - R) Diagram (Microsoft Visio ) ……………… Appendix (A) Data Flow Diagram (DFD) (Micro Visio). ………………………… .. Appendix (B)

11 more pages in the full document

Unlock it once and it stays in your library, ready to chat with or turn into flashcards.

Unlock the full document

More Information Technology study materials

See all

Study this document with CramX

Once it is in your library, every tool can work from it.