Develop a database schema diagram based on the excel files attached 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.