DAT 390 Wk 2 - Apply: U.S. Student Aid Initial Database Schema and Query Recommendations | eBooks | Education

DAT 390 Wk 2 - Apply: U.S. Student Aid Initial Database Schema and Query Recommendations

DAT 390 Wk 2 - Apply: U.S. Student Aid Initial Database Schema and Query Recommendations PLDZ-12535
In Stock
$ 9.00 USD
Buy and Download   > Description

***************************************************************

Click Here To Download Your Files : 

https://uopcourse.com/category/dat-390/

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

You can buy more tutorials from the below link.

https://uopcourse.com/

***************************************************************

DAT 390 Wk 2 – Apply: U.S. Student Aid Initial 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 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 Week 1 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®

 

 

    • Develop the SQL queries needed and populate the tables from the data downloaded for your Week 1 assignment. Your assignment should:

 

 

    • 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.

 

 

 

 

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.

*************************************************************** Click Here To Download Your Files : https://uopcourse.com/category/dat-390/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ You can buy more tutorials from the below link. https:
Recent Reviews Write a Review
0 0 0 0 reviews