CIS 499 Capstone Project Deliverable 3: Database and Data Warehousing Design

Capstone course for the Strayer Bachelor of Information Systems program. Project Deliverable 3: Database and Data Warehousing Design, contanins two files:
Exclusive and Original document Available only on Course Answer
In this deliverable, you will create a database schema that supports the company’s business and processes, explain and support the database schema, create database tables, normalize the database tables, create an Entity-Relationship (E-R) Diagram and create a Data Flow Diagram (DFD). You will also be asked to create sample queries that will support the organizational reporting needs and screen layouts that illustrate the interface that organizational users will utilize. You will need to update the project plan.
Submission Requirements
o Design Document (MS Word)
o Revised Project Plan (MS Project)


Download Now
(sent via email)


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.

Close Menu