Test your recommended U.S. Student Aid database schema, build the database, and develop the business intelligence queries that will enable you to answer the following project questions:
-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?
Revise the schema you submitted.
Test your schema by completing the following tasks:
-Define the database tables you will need and group 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 during the Week One Individual Assignment, “U.S. Student Aid Database Initial Database Schema.”
-Define an appropriate strategy to optimize and incorporate best practices in to the SQL that you created. -Document your SQL and metadata in Microsoft Visio or Microsoft Excel -Capture screenshots of each query result.
Document your results as a 1-page MicrosoftWord document that:
-Describes your SQL, populated tables, and the best practices you used to develop your SQL queries-Includes the SQL statements and corresponding screenshots of each query result
Compress your revised diagram(s), testing results documentation and SQL files into a ZIP file.