Database and Data Warehousing Design

Database and Data Warehousing Design

By Your Name (remove yellow)

CIS 499

Professor Roden

Date DD//MM//YYYY (REMOVE)

Database and Data Warehousing Design

Remove - Use this section to type an introduction- Write a four to six (4-6) page design document – not including Title, diagram, source page

in which you: Remove

REMOVE - Paragraphs – Start first sentience with either 5 to 7 spaces (Note: all paragraphs should be in unison - REMOVE.

Data Warehousing

Remove - Support the need for data warehousing within your company and elaborate on the best practices that the company will adhere to.- Remove.

Business and Processes

Remove - 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. THINK BACK TO YOUR CIS 170 Course-Remove

Entity-Relationship (E-R) Diagram

Remove - 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. Remove

Data Flow Diagram (DFD)

Remove - 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. Remove

Data Warehouse Inputs and Outputs.

Remove - 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. - Remove

Sources

Remove - The use of at least two (2) quality resources in this assignment. Note: Wikipedia and similar. Websites do not qualify as quality resources. PROVIDE IN-TEXT CITATION-Remove

1.

2.

3.