Posted on by Judy

Dat 390 Individual U S Student Aid Database Schema And Query Recommendations Thi

DAT/390 Individual: U.S. Student Aid Database Schema and Query Recommendations
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 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 in the Week One Individual Assignment, “U.S. Student Aid Initial Database Schema” per your instructor’s feedback.
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 4- to 5- slide Microsoft® PowerPoint® presentation or a 1-page Microsoft® Word 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

Note: The final Week Five Individual Assignment, “U.S. Student Data Debrief” requires a project summary and debrief that builds on this and subsequent Individual Assignments. Therefore, it is recommended that you select the delivery method of a Microsoft® PowerPoint® presentation or a Microsoft® Word document you will want to use consistently throughout these assignments.
Compress your revised diagram(s), testing results documentation and SQL files into a ZIP file.
Submit the ZIP file to the Assignment Files tab.
Hi, So I have already gotten this assignment from you, but I don’t know if the screenshots on the assignment is acceptable to my professor. Is there another  screenshot you could do that displays the SQL Query Results on MYSQL? Sorry in advance, I wasn’t sure how to reach you by email.
 
“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."

"Order a Custom Paper on Similar Assignment! No Plagiarism! Enjoy 20% Discount"

Related posts:

  1. Service company description
  2. Facebook use
  3. The experience of poor performance is universal; everyone has performed poorly at one time or another. The real significance of poor performance is found in correcting it—understanding why the poor performance occurred and developing plans to prevent similar poor performance in the future. The first step is describing the event in detail, including an assessment of how the performance came to be labeled as “poor”. The second step involves listing all the possible contributing causes of the poor performance. In doing so, consider internal as well as external factors. The rest of the process is largely useless if no plan is developed to ensure better performance in the future. How do you Correct Poor Performance? At one time or another, each of us has had a poor performance of some kind. It may have been a poor test result in school, a poor presentation at work, or a poor performance in an athletic event. Think of a poor performance event that you have experienced and work through the following three steps. Step 1. Briefly describe the specific event in some detail. Include why you label it a poor performance (bad score? someone else’s evaluation?). Step 2. Analyze the poor performance. a. List all the possible contributing causes to the poor performance. Be specific, such as the room was too hot, you did not get enough sleep, you were not told how to perform the task, etc. You might ask other people for possible ideas, too. 1. _________________________ 2. _________________________ 3. _________________________ 4. _________________________ 5. _________________________ 6. _________________________ 7. _________________________ b. Is there a primary cause for the poor performance? What is it? Step 3. Plan to correct the poor performance. Develop a step-by-step plan of action that specifies what you can change or do differently to improve your performance the next time you have an opportunity. Include seeking help if it is needed. Once your plan is developed, look for an opportunity to execute it.
  4. Develop a potential structure for effectively persuading readers to agree with your argument.