I need help with the assignment below. The first part is a word document.  The second part requires a Microsoft Project file which I have included and needs to be updated.I have also included the grading rubrick as well. 

 

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 (10) 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.

 

 

 

1/29/2017 https://blackboard.strayer.edu/bbcswebdav/institution/CIS/499/1128/Week5­1128/Week 5 Assignment 3 Grading Rubric.html Grading for this assignment will be based on answer quality, logic / organization of the paper, and
language and writing skills, using the following rubric.
Project Deliverable 3: Database and Data Warehousing Design Points: 110 Meets Minimum
Criteria
Unacceptable Expectations
Below 60% F
60­69% D
Section 1: Project Introduction
1a. Support the need Did not
Insufficiently
for data warehousing submit or
supported the
within your company incompletely need for data
and elaborate on the
supported the warehousing
best practices that the need for data within your
company will adhere warehousing company;
to.
within your insufficiently
Weight: 20%
company; did elaborated on the
not submit or best practices that
incompletely the company will
elaborated on adhere to.
the best
practices that
the company
will adhere to.
1b. Create a schema
Did not
Insufficiently
that supports the
submit or
created a schema
company’s business
incompletely that supports the
and processes. Explain created a
company’s
and support the
schema that business and
database schema with supports the processes.
relevant arguments that company’s
Insufficiently
support the rationale business and explained and
for the structure.
processes.
supported the
Weight: 20%
Did not
database schema
submit or
with relevant
incompletely arguments that
explained and support the
supported the rationale for the
database
structure.
schema with
relevant
arguments
that support
the rationale
for the
structure.
1c. Create an Entity­ Did not
Insufficiently
Relationship (E­R)
submit or
created an Entity­
Diagram relating the incompletely Relationship (E­
tables of your database created an
R) Diagram
schema through the use Entity­
relating the tables
of graphical tools in
Relationship of your database Fair
70­79% C Proficient
80­89% B Exemplary
90­100% A Partially
Satisfactorily
supported the supported the need for
need for data data warehousing
warehousing within your company;
within your satisfactorily
company;
elaborated on the best
partially
practices that the
elaborated on company will adhere
the best
to.
practices that
the company
will adhere to. Thoroughly
supported the
need for data
warehousing
within your
company;
thoroughly
elaborated on
the best
practices that
the company
will adhere to. Partially
created a
schema that
supports the
company’s
business and
processes.
Partially
explained and
supported the
database
schema with
relevant
arguments
that support
the rationale
for the
structure. Satisfactorily created a Thoroughly
schema that supports created a
the company’s business schema that
and processes.
supports the
Satisfactorily explained company’s
and supported the
business and
database schema with processes.
relevant arguments that Thoroughly
support the rationale explained and
for the structure.
supported the
database
schema with
relevant
arguments
that support
the rationale
for the
structure. Partially
created an
Entity­
Relationship
(E­R)
Diagram Satisfactorily created Thoroughly
an Entity­Relationship created an
(E­R) Diagram relating Entity­
the tables of your
Relationship
database schema
(E­R)
through the use of
Diagram https://blackboard.strayer.edu/bbcswebdav/institution/CIS/499/1128/Week5­1128/Week%205%20Assignment%203%20Grading%20Rubric.html 1/3 1/29/2017 https://blackboard.strayer.edu/bbcswebdav/institution/CIS/499/1128/Week5­1128/Week 5 Assignment 3 Grading Rubric.html Microsoft Visio or an
open source alternative
such as Dia. Explain
your rationale behind
the design of your E­R
Diagram.
Weight: 15% (E­R)
schema through relating the graphical tools in
relating the
Diagram
the use of
tables of your Microsoft Visio or an tables of your
relating the graphical tools in database
open source alternative database
tables of your Microsoft Visio or schema
such as Dia.
schema
database
an open source
through the Satisfactorily explained through the
schema
alternative such as use of
your rationale behind use of
through the Dia. Insufficiently graphical
the design of your E­R graphical
use of
explained your
tools in
Diagram.
tools in
graphical
rationale behind Microsoft
Microsoft
tools in
the design of your Visio or an
Visio or an
Microsoft
E­R Diagram.
open source
open source
Visio or an
alternative
alternative
open source
such as Dia.
such as Dia.
alternative
Partially
Thoroughly
such as Dia.
explained
explained
Did not
your rationale
your rationale
submit or
behind the
behind the
incompletely
design of your
design of your
explained
E­R Diagram.
E­R Diagram.
your rationale
behind the
design of your
E­R Diagram.
1d. Create a Data Flow Did not
Insufficiently
Partially
Satisfactorily created a Thoroughly
Diagram (DFD)
submit or
created a Data
created a Data Data Flow Diagram
created a Data
relating the tables of incompletely Flow Diagram
Flow Diagram (DFD) relating the
Flow Diagram
your database schema created a Data (DFD) relating the (DFD)
tables of your database (DFD)
through the use of
Flow Diagram tables of your
relating the schema through the use relating the
graphical tools in
(DFD)
database schema tables of your of graphical tools in
tables of your
Microsoft Visio or an relating the through the use of database
Microsoft Visio or an database
open source alternative tables of your graphical tools in schema
open source alternative schema
such as Dia.
database
Microsoft Visio or through the such as Dia.
through the
Weight: 15%
schema
an open source
use of
use of
through the alternative such as graphical
graphical
use of
Dia.
tools in
tools in
graphical
Microsoft
Microsoft
tools in
Visio or an
Visio or an
Microsoft
open source
open source
Visio or an
alternative
alternative
open source
such as Dia.
such as Dia.
alternative
such as Dia.
1e. Illustrate the flow Did not
Insufficiently
Partially
Satisfactorily
Thoroughly
of data including both submit or
illustrated the
illustrated the illustrated the flow of illustrated the
inputs and outputs for incompletely flow of data
flow of data data including both
flow of data
the use of a data
illustrated the including both
including both inputs and outputs for including both
warehouse. The
flow of data inputs and outputs inputs and
the use of a data
inputs and
diagram must map data including both for the use of a
outputs for
warehouse.
outputs for
between source
inputs and
data warehouse. the use of a Satisfactorily mapped the use of a
systems, data
outputs for
Insufficiently
data
data between source
data
warehouses, and
the use of a mapped data
warehouse. systems, data
warehouse.
specified data marts. data
between source Partially
warehouses, and
Thoroughly
Weight: 15%
warehouse. systems, data
mapped data specified data marts. mapped data
Did not
warehouses, and between
between
https://blackboard.strayer.edu/bbcswebdav/institution/CIS/499/1128/Week5­1128/Week%205%20Assignment%203%20Grading%20Rubric.html 2/3 1/29/2017 https://blackboard.strayer.edu/bbcswebdav/institution/CIS/499/1128/Week5­1128/Week 5 Assignment 3 Grading Rubric.html submit or
specified data
source
source
incompletely marts.
systems, data
systems, data
mapped data
warehouses,
warehouses,
between
and specified
and specified
source
data marts.
data marts.
systems, data
warehouses,
and specified
data marts.
Section 2: Revised Project Plan
2. Update the project Did not
Insufficiently
Partially
Satisfactorily updated Thoroughly
plan
submit or
updated the
updated the the project plan
updated the
fromProjectDeliverable incompletely project plan from project plan fromProjectDeliverable project plan
2: Business
updated the ProjectDeliverable fromProject 2: Business
fromProject
Requirements, with
project plan 2: Business
Deliverable 2: Requirements, with
Deliverable 2:
three to five (3­5) new fromProject Requirements,
Business
three to five (3­5) new Business
project tasks each
Deliverable 2: with three to five Requirements, project tasks each
Requirements,
consisting of five to ten Business
(3­5) new project with three to consisting of five to ten with three to
(5­10) sub­tasks.
Requirements, tasks each
five (3­5) new (5­10) sub­tasks.
five (3­5) new
Weight: 5%
with three to consisting of five project tasks
project tasks
five (3­5) new to ten (5­10) sub­ each
each
project tasks tasks.
consisting of
consisting of
each
five to ten (5­
five to ten (5­
consisting of
10) sub­tasks.
10) sub­tasks.
five to ten (5­
10) sub­tasks.
3. Clarity, writing
More than 8 7­8 errors present 5­6 errors
3­4 errors present
0­2 errors
mechanics, and
errors present
present
present
formatting
requirements
Weight: 10% https://blackboard.strayer.edu/bbcswebdav/institution/CIS/499/1128/Week5­1128/Week%205%20Assignment%203%20Grading%20Rubric.html 3/3

Attachments:

• 1493886182-Grading Rubrick.pdf