ARCHITECTURE AND IMPLEMENTATION OF A RELATIONAL DATABASE FOR A BASIC HEALTH UNIT: A CASE STUDY AT UBS NOVA VITÓRIA

Abstract

To describe the modeling and implementation process of a relational database for information management at the Nova Vitória Basic Health Unit (Imperatriz/MA). Methodology: A case study with a qualitative approach, based on direct observation and semi-structured interviews with six professionals from the unit. The database was modeled in MySQL Workbench based on the requirements gathered. Results: The implementation resulted in a 64.7% reduction in the average patient registration time (from 8.5 to 3.0 minutes), an 86.7% reduction in the estimated rate of scheduling errors (from ~15% to <2%), a 92% reduction in inventory verification time (from 25 to 2 minutes), and an 85.7% reduction in the number of out-of-stock medications per month (from 7 to 1). All six interviewed professionals reported improvements in their work routines. Conclusion: The study proposes a replicable database architecture for BHU, demonstrating that the integrated application of relational model fundamentals can solve chronic data management problems in primary care. The scientific contribution consists of offering an empirically validated technical model, adaptable to other SUS units.