Challenge Overview
When Soteria needs to provide data from an application database to another party, the data must first be scrubbed of any sensetive information. There is a process in place for identifying which columns and tables must be scrubbed and how the scrubbing must be done. Part of the process is to perform a verification against the data after it has been scrubbed in order to show that the sensetive data has been removed. This verification is done by creating a Comparison Report between the data contained in two versions of the same database/structure (the scrubbed version and the original version). This project is to develop a program which will automatically create this Comparison Report.
The attached document shows example inputs, describes the process which the tool needs to execute and shows example outputs that must be created (the report).