DEVELOPMENT OF AN OFFLINE ANDROID-BASED LIBRARY BORROWING SYSTEM USING SQLITE DATABASE

Abstract

Many institutional libraries still rely on manual borrowing records, causing difficulties in transaction tracking, stock monitoring, and accurate fine calculation. This condition reduces service efficiency and increases the risk of data errors in library administration. To address this problem, this study develops an Android-based Library Book Borrowing System as a digital library management solution. The system was developed using a structured Software Development Life Cycle (SDLC) approach consisting of analysis, design, implementation, and testing phases, employing the Java programming language and a locally embedded SQLite relational database. Unlike cloud-dependent approaches, the proposed system operates entirely without an internet connection, making it suitable for institutions with limited network infrastructure. The system encompasses five core modules: book management, member registration, borrowing and return transactions, automated fine computation, and reporting. A distinctive three-tier validation mechanism—comprising stock availability verification, membership status authentication, and outstanding fine arrear inspection—enforces transactional integrity and prevents unauthorized borrowing. Black-box testing confirmed that all 10 primary functional features achieved a 100% success rate. Media expert validation further affirmed the system's high feasibility for deployment as a fully operational digital library management solution.