Design And Development Of An Application For Database Maintenance In Inventory Management System Using Tkinter And Sqlite Platform

Abstract

The challenges in classical way of inventory log are human mathematical ability, paper maintenance, untidy process of editing and chances of missing the data of invoice and outward. The proposed idea is to develop an inventory management application using Tkinter and SQLite platform that creates a way towards progressively from traditional applications to a fully connected and customized inventory management system. This application uses password encryption to ensure the data privacy between the administrators and other workers of the industry. The system utilizes the integration of Tkinter and SQLite for the effective Graphical User Interface interfaced with Relational Database Management System. This customized application enables the administrator to add a new employee or remove the existing employee, he can update the stock quantity, and can back up the invoice history. Due to the login feature, the details of the product outward such as who withdrew and when it was withdrawn are automatically stored in the database. This digitization of inventory management system increases flexibility, reliability, smart storage, resource utilization, easy access to product location and warehouse management. It would be one time investment no further investment needed if at all any problem or errors occur in the app by human mishandling. The application saves us a lot of time because it uses SQL in it which is structured language, the data can be retrieved soon without any time delay and the human errors are avoided due to its structured nature.