CODEX: Journal of Software Engineering
Vol 1, No 3 (2026): September 2026

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

Lisa Almayanti (STKIP Taman Siswa Bima)
M. khizbullah (STKIP Taman Siswa Bima)
Ardian Ardian (STKIP Taman Siswa Bima)
Nur Fitrianingsih (STKIP Taman Siswa Bima)



Article Info

Publish Date
30 Sep 2026

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.

Copyrights © 2026






Journal Info

Abbrev

CODEX

Publisher

Subject

Description

CODEX: Journal of Software Engineering is a peer-reviewed scientific journal dedicated to the dissemination of high-quality research, theoretical studies, and technological innovations in the field of software engineering. The journal focuses on advancing knowledge and best practices in software ...