This week you will continue youru202fwork onu202ftheu202fproject to evaluate higher education student aid data. Youu202fwill test your recommended U.S. Student

This week you will continue your
u202fwork on
u202fthe
u202fproject to evaluate higher education student aid data. You
u202fwill test your recommended U.S. Student Aid database schema,
u202fbuild the database,
u202fand develop the business intelligence queries that will enable you to answer
u202fthe following questions (due in Week 5):
Which schools generate the highest amount of debt for the average student who attends?
What is the employment rate for the students who graduate from this school?
————————
For Week 2:
Revise the schema you submitted in Week 1
per your instructor’s feedback.
Test your schema by completing the following tasks:
Define the database tables you will need and
u202fgroup the tables by function. Document your tables in an annotated Microsoft® Visio® diagram.
Develop the SQL queries needed and populate the tables from the data downloaded for your Week 1 assignment. Your assignment should:
Define
u202fan appropriate strategy to optimize and incorporate best practices in to
u202fthe SQL that you created.
Document your SQL and metadata in Microsoft® Visio® or Microsoft® Excel®.
Capture screenshots of each query result.
Note: You may mock up the SQL statement and query results if you do not want to download a database.
Document
your results as a 1-page Microsoft®Word document that:
Describe your SQL, populated tables, and the best practices you used to develop your SQL queries
Include the SQL statements and corresponding screenshots of each query result
Compress your revised diagram(s), testing results documentation, and .SQL files into a ZIP folder.
Submit your assignment.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Connect with a professional writer in 5 simple steps

Please provide as many details about your writing struggle as possible

Academic level of your paper

Type of Paper

When is it due?

How many pages is this assigment?

Place Order