JK TOOLS FOR DETECTION AND CORRECTION ERRONEOUS DATA FROM DATABASE.

Correcting data from impurities is an integral part of data processing and maintenance. One important aspect of JK TOOLS is identification of the basic causes of the errors detected and using that information to improve the data entry process to prevent those errors from reoccurring. It discusses guidelines, methods and tools that can assist museums and herbaria to follow best practice in digitising, documenting and validating information. This paper is based on the concept about how to avoid dirty and faulty data to get populated in the databases as well as data files. Most of the databases are only providing the data validation techniques in the form of integrity constraints which is useful for valid data entry. But in most of the database such as M.S Excel which is also considered as good earlier version of the database fails to provide the running JK TOOLS and data validation techniques, In short in case of any spelling correction it is not possible to correct it automatically as in the case of M.S.Word where it is provided the facility of current JK TOOLS procedure by providing the list of related spelling, it also warns the user in the form of green and red wavy lines which is not available in the any of the database. Our research work is to provide such kind of JK TOOLS algorithms in the form of in build procedure.