Assignment: 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 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
• 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 in Microsoft Visio that includes:
• 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.
Format your assignment according to the following formatting requirements:
i) The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
ii) The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
iii) Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.