DAT/390 Database Integration with Other Systems The Latest Version A+ Study Guide
**********************************************
DAT 390 Entire Course Link
http://www.uopstudy.com/dat-390
DAT 390 Wk 1 - Apply: U.S. Student Aid Initial Database Schema You are assigned a project to evaluate higher education student aid data from the U.S. government 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? You will complete this cumulative project throughout the course This week, you will complete an initial review of the data and prepare an initial database schema and data discrepancy recommendation. Download the following spreadsheets or CSV files:
School Code List (this link is not working for some reason but luckily I have this file from a recent previous class): 2021FedSchoolCodeList.xlsx
Most current spreadsheets for Loan Volume, Grant Volume, and Campus-Based Volume
Gainful Employment Information Develop a database schema diagram based on the data tables you downloaded. Use Microsoft® Visio® to display your diagram. Your diagram should include:
The identification of metadata that needs to be included in each table
Annotation of the diagram to identify where there may be schematic discrepancies between the data sources Summarize your recommendations for resolving anticipated discrepancies and identify which strategy you would use to validate the data quality in a Microsoft® Word document. Note: You will use the downloaded files and your drafted schema in the Week 2 individual assignment, U.S. Student Aid Database Schema and Query Recommendations. Submit your Microsoft® Visio® file and Word® file.
For More Classes Please Visit
http://www.uopstudy.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® diagram.
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.
For More Classes Please Visit
http://www.uopstudy.com/ DAT 390 Wk 3 - Apply: U.S. Student Aid Data Warehouse Development This week you will continue your work on the project to evaluate higher education student aid data. You will transform your operational data structure and schema into a data structure and schema for a data warehouse, which will be exclusively used for reporting. Develop a plan to integrate this new data warehouse with an internet application. Include in your plan:
A description of the transformation process
A schema diagram identifying the changes needed
Revise the diagram you submitted in Week 2 per your instructor’s feedback.
Specific integration plans Document your plan as either:
A 1- to 2-page Microsoft® Word document
A 6- to 7-slide Microsoft® PowerPoint® presentation with detailed speaker notes
Note: It is recommended that you select the delivery method of a Microsoft® PowerPoint® presentation or a Microsoft® Word document to use consistently throughout your weekly assignments. Compress your revised diagram and your plan into a ZIP folder. Submit your assignment.
DAT 390 Wk 4 - Apply: U.S. Student Aid Data Warehouse Evaluation This week you will continue your work on the project to evaluate higher education student aid data. You will evaluate your data warehouse data to ensure it can provide consistent, accurate query data, and provide an update to the project sponsors. Define and execute a process to evaluate your data warehouse data for incompleteness, nulls, and the ability to provide consistent query data. Create a summary for your project sponsors to inform them of the quality of data they can expect from the new data warehouse. Include the following information in your summary:
Your data evaluation strategy
Specific data evaluation queries
Sample results per query
Summary of findings Document your summary as either:
A 10-slide Microsoft® PowerPoint® presentation with detailed speaker notes
A 2-page Microsoft® Word document Note: It is recommended that you select the delivery method of a Microsoft® PowerPoint® presentation or a Microsoft® Word document to use consistently throughout your weekly assignments. Submit your assignment.
For More Classes Please Visit
http://www.uopstudy.com/