Data warehousing design

Assignment Help Database Management System
Reference no: EM13726498

Database and Data Warehousing Design

Must be able to use MS Project or simliar software

This assignment consists of two (2) sections: a design document and a revised project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment it is written for. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

One of the main functions of any business is to be able to use data to leverage a strategic competitive advantage. This feat hinges upon a company's ability to transform data into quality information. The use of relational databases is a necessity for contemporary organizations; however, data warehousing has become a strategic priority due to the enormous amounts of data that must be analyzed along with the varying sources from which data comes. Since you are now the CIO of a data-collection company which gathers data by using Web analytics and operational systems, you must design a solution overview that incorporates data warehousing. The executive team needs to be clear about what data warehousing can provide the company.

Section 1: Design Document

Write a four to six (4-6) page design document in which you:

  • Support the need for data warehousing within your company and elaborate on the best practices that the company will adhere to.
  • Create a schema that supports the company's business and processes. Explain and support the database schema with relevant arguments that support the rationale for the structure. Note: The minimum requirement for the schema should entail the tables, fields, relationships, views, and indexes.
  • Create an Entity-Relationship (E-R) Diagram relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix. Explain your rationale behind the design of your E-R Diagram.
  • Create a Data Flow Diagram (DFD) relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix.
  • Illustrate the flow of data including both inputs and outputs for the use of a data warehouse. The diagram must map data between source systems, data warehouses and specified data marts. The diagram should map data between source systems, data warehouses, and specified data marts. Note: The graphically depicted solution is not included in the required page length.

Your assignment must follow these formatting requirements:

  • Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
  • Include a cover page containing the title of the assignment, the student's name, the professor's name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
  • Include charts or diagrams created in MS Visio or Dia as an appendix of the design document. All references to these diagrams must be included in the body of the design document.

Section 2: Revised Project Plan

Use Microsoft Project to:

  • Update the project plan from Project Deliverable 2: Business Requirements, with three to five (3-5) new project tasks each consisting of five to ten (5-10) sub-tasks.

The specific course learning outcomes associated with this assignment are:

  • Summarize how information systems represent a key source of competitive advantage for organizations.
  • Develop information systems-related activities to maximize the business value within and outside the organization.
  • Use technology and information resources to research issues in information systems.
  • Write clearly and concisely about strategic issues and practices in the information systems domain using proper writing mechanics and technical style conventions.

Reference no: EM13726498

Questions Cloud

Corporate strategies are divided to long-term and short-term : Corporate Strategies are divided to long-term and short-term.
Prepare a pppt on health care reform : Health care reform is a topic that is likely to be debated for a long time to come. Imagine yourself as a crafter of health care solutions for this county and you are charged with presenting your solution to a bipartisan group of citizens and legi..
Replace a computer system with a new model : TelCo must decide whether to replace a computer system with a new model. TelCo forecasts net before tax cost savings from the new computer over five years as given below (in $000). It has a 12 percent cost of capital, a 35 percent tax rate, and..
How to create an email newsletter : Read the following articles: 15 Email Newsletter Examples We Love Getting in Our Inboxes, How to Create an Email Newsletter [Checklist]
Data warehousing design : Update the project plan from Project Deliverable 2: Business Requirements, with three to five (3-5) new project tasks each consisting of five to ten (5-10) sub-tasks.
Calculate the amount of additional funds : 1. Please complete the forecast for three years of the income statement and the balance sheet, using the spreadsheet. 2. Calculate the amount of additional funds needed for each of the three years.
Derive demand curves for ggcs product in each market : Derive GGC's marginal revenue (MR) and marginal cost (MC) curves in each market. Show graphically GGC's demand, MR, and MC curves for each market.
Calculate the npv of walking the dragline : 1) Calculate the NPV of walking the dragline. 2) Calculate the NPV of employing contractors. 3) What recommendation should Horwill make to the CFO?
What were the causes of world war i : Why should a rebellion in Cuba - an internal affair of Spain's - become a cause for war with the United States? What were the causes of World War I? What made it a "world" war?

Reviews

Write a Review

 

Database Management System Questions & Answers

  Explain denormalized table in normal form

The DBA denormalized some of the data in the Premiere Products database to improve performance. Which field or fields cause the table to no longer be in third normal form? In which normal form is the denormalized table?

  Would not this result in pure gibberish most of the time

In a "chosen ciphertext attack" the attacker has the option of choosing the ciphertext sample and having it decrypted by someone who knows the key. Wouldn't this result in pure gibberish most of the time?

  Relations of airline flight information

The relations given below keep track of airline flight information:Flights(flno: integer, from: string, to: string, distance:integer, departs: time, arrives: time, price: real)Aircraft(aid: integer, aflame: string, cruisingrange: integer)

  Design and build a small database application

Refine research and analysis skills through locating, selecting and compiling a higher-level research essay.

  Construct an er diagram for a hospital

Construct an er diagram for a hospital with a set of patients and a set of medical doctors. associate with each patient a log of various test and examination conducted.convert er diagram into tables

  Delete an existing product from the database

Utilise an include statement to refer to connection.php instead of the long version of the database connection code so that you can keep the database more secure. See Notes for more details.

  Create a table for patients with information

Create a table (by your own imagination) which comprises the least 25 patients with next information (columns): Calculate average of Value1 for each Gender.

  Your boss has just heard about some nefarious computer

your boss has just heard about some nefarious computer activities called ping sweeps and port scans. he wants to know

  Find names of students who have higher gpa from table

List the students ID, name, GPA, and course Number such that all students have GPA greater than 3 . 5 and enrolled in a course in Jan 1, 2011. Find the names of all students who have GPA greater than 3.

  Write steps to follow to create the relational database

Write down short description of database connectivity with Internet using one of widely disseminated technologies. (that is using either active server pages or Java server pages or others).

  Create an update query to select all records in the tbl over

Create an update query to select all records in the tblOverPriced, decrease the Price field values by 10%, run and close the query.

  Difference between manufacturing and service industries

Discuss whether the ERP software is mostly suitable for manufacturing companies or whether it can be used in service industries also.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd