Database Development 3

 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.