This Week You Willcontinueyourwork Ontheproject To Evaluate Higher This week you will continue your work on the project to evaluate higher education student aid data. You will test your recommended U.S. Student Aid database schema, build the database, and develop the business intelligence queries that will enable you to answer questions such as which schools generate the highest amount of debt for the average student who attends, and what is the employment rate for students who graduate from these schools. For Week 2, revise the schema you submitted in Week 1 based on your instructor’s feedback. Test your schema by defining the necessary database tables, grouping them by function, and documenting your tables in an annotated Microsoft® Visio® diagram. Develop the SQL queries needed, and populate the tables with data downloaded for your Week 1 assignment. Ensure that your SQL incorporates best practices and an optimized strategy. Document your SQL and metadata in Microsoft® Visio® or Microsoft® Excel®, including detailed annotations or descriptions. Capture screenshots of each query result to demonstrate successful execution and correct data retrieval. If preferred, you may mock up SQL statements and query results instead of actual database download. Your final submission should include a one-page Microsoft® Word document describing your SQL code, the populated tables, and the best practices used in developing your SQL queries. Include the actual SQL statements and the corresponding screenshots of query results. Compress all related files—your revised diagrams, testing documentation, SQL files, and screenshots—into a ZIP folder and submit it as your assignment.
Paper For Above instruction The task of evaluating higher education student aid data through database management and business intelligence tools encompasses several critical phases, including schema design, data population, query development, and documentation of best practices. This comprehensive process aims to facilitate meaningful insights into student debt levels and employment outcomes of graduates, which are pivotal metrics for policymakers, educational institutions, and prospective students seeking transparency and understanding of financial aid impacts. Initially, revising the database schema based on instructor feedback is crucial to ensure the design aligns