Database Development 3

profileProfSteven

 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. 

  • 5 years ago
  • 50
Answer(1)

Purchase the answer to view it

blurred-text
  • attachment
    sql.zip
  • attachment
    DatabaseSchema.docx
  • attachment
    dbase.zip