Week3-us student aid data warehouse

This week you will continue your work on the project to evaluate higher education student aid data. You will transform your operational data structure and schema into a data structure and schema for a data warehouse, which 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 either a:

• 1- to 3-page Microsoft® Word document
• 6- to 8-slide Microsoft® PowerPoint® presentation with detailed speaker notes

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

Submit your assignment.