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.
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."
