DEVELOPMENT OF AN INTEGRATED DATABASE MANAGEMENT SYSTEM FOR PUBLIC HOUSING ESTATE ADMINISTRATION: A CASE STUDY OF MAI MALAH HOUSING ESTATE, ALONG MAIDUGURI-GASHUA BYPASS, DAMATURU, YOBE STATE, NIGERIA

Abstract

This study addresses critical inefficiencies in manual record-keeping systems in Nigerian public housing by developing an integrated database system for Mai Malah Housing Estate, Damaturu, Yobe State. Methodology: Grounded in the Technology-Organization-Environment (TOE) framework, the study employed a hybrid methodological approach combining field reconnaissance using GPS technology, spatial data processing in ArcGIS 10.7.1, and relational database design in MySQL following Systems Development Life Cycle (SDLC) principles. Findings: The implemented system managed 147 property records with an average query response time of 0.43 seconds, representing a 99.97% improvement over manual methods. Database analysis revealed estate composition of 118 residential parcels (80.3%) and 29 commercial parcels (19.7%), with occupancy patterns showing 68 male-headed (46.3%) and 52 female-headed households (35.4%). Practical Implications: The study provides a validated implementation blueprint for digital transformation in Nigeria's public housing sector, offering practical solutions to data fragmentation and inefficiency challenges while demonstrating substantial operational benefits. This research contributes a comprehensive case study of integrated database system implementation in Nigeria's secondary cities, extending the TOE framework to post-conflict housing contexts and providing empirical performance metrics for technology adoption decisions.