The automation of shareholder information management in a sugarcane factory plays a crucial role in improving data accuracy, accessibility, and operational efficiency. This research work focuses on automating the storage, retrieval, and management of shareholder data using SQL queries within an MS-Access database, integrated with the ASP.NET framework for Bhimashankar Sugar factory. The system is designed to store essential shareholder information, such as personal details, shareholding percentages, transaction histories, and voting rights, in a stored structured MS-Access database. By leveraging the ASP.NET framework, a web-based interface is developed, allowing users to interact with the database for querying, updating, and producing reports on shareholder data in real-time entity. SQL queries facilitate efficient data handling and ensure the truthfulness of shareholder records. The use of MS-Access provides an affordable, scalable, and user-friendly database solution while simplifying the process of automating and managing shareholder information. This system enhances data accuracy, security, and transparency, enabling the sugar factory's management to make informed decisions and fostering better communication with its investors.
Wali et al. (Sat,) studied this question.