CS week 5 Assignment 3

Points: 110

Project Deliverable 3: Database and Data Warehousing Design

Criteria

Unacceptable Below 60% F

Meets Minimum Expectations 60-69% D

Fair 70-79% C

Proficient 80-89% B

Exemplary 90-100% A

Section 1: Project Introduction

1a. Support the need for data warehousing within your company and elaborate on the best practices that the company will adhere to. Weight: 20%

Did not submit or incompletely supported the need for data warehousing within your company; did not submit or incompletely elaborated on the best practices that the company will adhere to.

Insufficiently supported the need for data warehousing within your company; insufficiently elaborated on the best practices that the company will adhere to.

Partially supported the need for data warehousing within your company; partially elaborated on the best practices that the company will adhere to.

Satisfactorily supported the need for data warehousing within your company; satisfactorily elaborated on the best 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.

1b. 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. Weight: 20%

Did not submit or incompletely created a schema that supports the company’s business and processes. Did not submit or incompletely explained and supported the database schema with relevant arguments that support the rationale for the structure.

Insufficiently created a schema that supports the company’s business and processes. Insufficiently explained and supported the database schema with relevant arguments that support the rationale for the structure.

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 schema that supports the company’s business and processes. Satisfactorily explained and supported the database schema with relevant arguments that support the rationale for the structure.

Thoroughly created a schema that supports the company’s business and processes. Thoroughly explained and supported the database schema with relevant arguments that support the rationale for the structure.

1c. 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. Explain your rationale behind the design of your E-R Diagram. Weight: 15%

Did not submit or incompletely created 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. Did not submit or incompletely explained your rationale behind the design of your E-R Diagram.

Insufficiently created 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. Insufficiently explained your rationale behind the design of your E-R Diagram.

Partially created 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. Partially explained your rationale behind the design of your E-R Diagram.

Satisfactorily created 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. Satisfactorily explained your rationale behind the design of your E-R Diagram.

Thoroughly created 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. Thoroughly explained your rationale behind the design of your E-R Diagram.

1d. 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. Weight: 15%

Did not submit or incompletely created 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.

Insufficiently created 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.

Partially created 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.

Satisfactorily created 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.

Thoroughly created 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.

1e. 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. Weight: 15%

Did not submit or incompletely illustrated the flow of data including both inputs and outputs for the use of a data warehouse. Did not submit or incompletely mapped data between source systems, data warehouses, and specified data marts.

Insufficiently illustrated the flow of data including both inputs and outputs for the use of a data warehouse. Insufficiently mapped data between source systems, data warehouses, and specified data marts.

Partially illustrated the flow of data including both inputs and outputs for the use of a data warehouse. Partially mapped data between source systems, data warehouses, and specified data marts.

Satisfactorily illustrated the flow of data including both inputs and outputs for the use of a data warehouse. Satisfactorily mapped data between source systems, data warehouses, and specified data marts.

Thoroughly illustrated the flow of data including both inputs and outputs for the use of a data warehouse. Thoroughly mapped data between source systems, data warehouses, and specified data marts.

Section 2: Revised Project Plan

2. Update the project plan fromProjectDeliverable 2: Business Requirements, with three to five (3-5) newproject tasks each consisting of five to ten (5-10) sub-tasks. Weight: 5%

Did not submit or incompletely updated the project plan fromProject Deliverable 2: Business Requirements, with three to five (3-5) newproject tasks each consisting of five to ten (5-10) sub-tasks.

Insufficiently updated the project plan from ProjectDeliverable 2: Business Requirements, with three to five (3-5) new project tasks each consisting of five to ten (5-10) sub-tasks.

Partially updated the project plan fromProject Deliverable 2: Business Requirements, with three to five (3-5) newproject tasks each consisting of five to ten (5-10) sub-tasks.

Satisfactorily updated the project plan fromProjectDeliverable 2: Business Requirements, with three to five (3-5) newproject tasks each consisting of five to ten (5-10) sub-tasks.

Thoroughly updated the project plan fromProject Deliverable 2: Business Requirements, with three to five (3-5) newproject tasks each consisting of five to ten (5-10) sub-tasks.

3. Clarity, writing mechanics, and formatting requirements Weight: 10%

More than 8 errors present

7-8 errors present

5-6 errors present

3-4 errors present

0-2 errors present