Using the database schema attached, transform the operational data structure and schema into a data structure and schema for a data warehouse that will be exclusively used for reporting. Develop a pl

Using the database schema attached, transform the operational data structure and schema into a data structure and schema for a data warehouse that will be exclusively used for reporting.

Develop a plan to integrate this new data warehouse with an Internet application. Include in your plan:

A description of the transformation process

A schema diagram identifying the changes needed (revise the diagram you submitted for the Week Two Individual Assignment, “U.S. Student Aid Database Schema and Query Recommendations” per your instructor’s feedback)

Specific integration plans

Document your plan as a:

3-page Microsoft® Word document

Compress your revised database diagram and your plan into a ZIP file.