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

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 2-page Microsoft® Word document
  • A 6- to 7-slide Microsoft® PowerPoint® presentation with detailed speaker notes

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

Submit the ZIP file to the Assignment Files tab.