Ardian Ardian
STKIP Taman Siswa Bima

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

DEVELOPMENT OF AN OFFLINE ANDROID-BASED LIBRARY BORROWING SYSTEM USING SQLITE DATABASE Lisa Almayanti; M. khizbullah; Ardian Ardian; Nur Fitrianingsih
CODEX: Journal of Software Engineering Vol 1, No 3 (2026): September 2026
Publisher : Nurul Jadid University, Paiton Probolinggo, East Java

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.33650/codex.v1i3.16073

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.