Create an entity-relationship diagram

Assignment Help Database Management System
Reference no: EM13761639

Project Deliverable: Database and Data Warehousing Design

This assignment consists of two (2) sections: a design document and a revised project plan.

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.

Section 2: Revised Project Plan

Use Microsoft Project to:

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

Reference no: EM13761639

Questions Cloud

Internal control and risk evaluation : Management at Kudler Fine Foods has reviewed the flowcharts prepared for payroll, accounts payable, accounts receivable, and inventory processes in Week Two and is requesting information on controls that will be required.
What types of future payment products and services : What types of future payment products and services should be anticipated and prepared for by the EA group? What is your vision of how payments might work
Visual basic programming : Write a 1- to 2-page paper discussing what online groups or sites you will follow to get insight into using Visual Basic® programming in your work or career?
Demonstrate full understanding of the issue : Demonstrate full understanding of the issue with reference to the extant literature - demonstrate partial understanding of the issue with reference to the extant literature
Create an entity-relationship diagram : 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
Proposed audit schedules for the systems : Management at Kudler Fine Foods now wants to see the proposed audit schedules for the systems analyzed by your team in Week Two.
Implement as a result of the information revolution : What changes in organization structure might you implement as a result of the information revolution?
Calculate a marginal cost and an average cost schedule : Calculate a marginal cost and an average cost schedule for the firm. If the prevailing marketing price is $17 per unit, how many units will be produced and sold. What are the profits per unit. What are the total profits
Problem related to engaging colleagues. : Describe several challenges you see to engaging your colleagues or students in critiquing the data analysis section of a report.

Reviews

Write a Review

 

Database Management System Questions & Answers

  Discuss social engineering techniques

Discuss how the information gathered during your footprinting analysis could be used to initiate an attack against the organization. Discuss social engineering techniques that could be utilized to gather information regarding the organization's com..

  Write benefits of using dbms to manage data in program

Describe briefly what are the main benefits of using DBMS to manage data in program applications involving extensive data access.

  Dba denormalized products database to enhance performance

The DBA denormalized some of the data in Premiere Products database to enhance performance, and one of the resulting tables is following.

  Optimizing sql server query performance how to optimizing

how to optimizing sql server query performance? when optimizing your database server you need to tune the performance

  Ray henry is considering expanding the inventory at his

ray henry is considering expanding the inventory at his book stores to include movies. he has some special ideas for

  Optimizing database design

Optimal database design recognizes proper organization of table structures and relationships. Suggest at least two methods that can be used to improve the design of a database system

  Explain the statement that relational algebra operators can

Explain the statement that relational algebra operators can be com-posed. Why is the ability to compose operators important?

  Analyzing hard-to-obtain data from two separate databases

You are interested in analyzing some hard-to-obtain data from two separate databases. Each database contains n numerical values.

  A simple database with a single table contains data

a simple database with a single table contains data concerning rental properties in australia. the table contains five

  Give preliminary information on data requirements for gis

You have been requested to give preliminary information on the data requirements for a GIS which is to be used to hold inventory of continental scale vegetation maps for coarse scale land surface

  Create a dtd file and an xsd file that specify the schemas

Create an XML file that describes 3 product elements; each product has three sub-elements: id, name, and description.

  Questioncandywarehouse is an online candy store the store

questioncandywarehouse is an online candy store. the store purchases candies from various vendors and one of them is

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