Finding the duplicates in a database seems to be quite simple but the requirements of the company made it more complicated. This company is very old and keeps track of their customers for many years now. But on the other hand, there are also new data that are imported in the database. Therefore, some companies may have changed their address for example and then it is more difficult to understand if they are duplicate entries. Moreover, the human factor plays an important role in this checking, since some companies have differences in their name due to mistyping, although they are the same.
Nevertheless, in this example it is presented the user interface that was created for this project. Since the company wanted to use this program in other databases, it was essential to create an interface that would help to connect with other databases and specify the field names of the database.
Except the part that the user is connected to the database, in this project it was required a progress bar, since it is essential to show the progress of the program due to its long duration.
Finally, it was requested to present the duplicates and the ones that there is a chance that they are duplicates. For this reason, a frame was created containing this information.
In this frame, there are two tables where change their data with the buttons "Previous" and "Next". The first window is the one that shows the duplicates and the second is the one that shows the "almost" duplicates. It is important to mention that there is not a check about two different entries, but even more than two entries, which are duplicates, can be presented in the frame.
