Developa 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

Summarizeyour recommendations for resolving anticipated discrepancies and identify which strategy you would use to validate the data quality in a MicrosoftWord document.

Note:You will use the downloaded files and your drafted schema in the Week 2individual assignment, U.S. Student Aid Database Schema and Query Recommendations.

Submit your Microsoft Visio file and Word file.