Development of an Information System for the Optimization of Production Processes in the "Victoria Dents" Dental Laboratory

Abstract— This paper describes the development and implementation of an automated information system for the "Victoria Dents" dental laboratory in Maracay, Venezuela. The facility faced critical inefficiencies due to manual record-keeping, leading to data loss and operational delays. Utilizing the Participatory Action Research (PAR) methodology and the Scrum agile framework, a web-based solution was designed using PHP, MySQL, and the XAMPP architecture. Results demonstrate a significant improvement in job traceability, inventory control, and customer satisfaction through the digitalization of billing and production tracking.I. Introduction In the digital era, automation is vital for business competitiveness. The "Victoria Dents" laboratory, specialized in dental prosthetics and maxillary orthopedics, operated under a manual scheme that generated an "implementation gap" and financial risks. The primary objective of this project was to develop a system to centralize the management of appointments, work requests, production, inventory, and billing. II. Methodology The PAR methodology was applied, actively involving laboratory staff in the diagnosis and evaluation phases. For software development, Scrum was utilized, dividing the work into sprints to allow for incremental deliveries and rapid adjustments based on the requirements of the director, Leiny Raquel Molina. Technologies: PHP (logic), HTML/CSS/JavaScript (interface), MySQL (database), and XAMPP (local server). Phases: Diagnosis of the current situation, identification of functional and non-functional requirements, conceptual design (ERD and use cases), construction, and validation testing. III. Results and Execution The implemented system features integrated modules that allow for: Appointment Control: Management of delivery dates and customer registration. Production Tracking: Monitoring the progress of each prosthetic piece and the raw materials used. Security: Password encryption and action audits performed by users. Reporting: Generation of real-time statistics and PDF documents for strategic decision-making. Testing phases revealed that the automation of the "Victoria Dents" workflow eliminated frequent errors in data organization and significantly reduced response times for dentist inquiries. IV. Conclusion The transition from manual records to an automated system eliminated information loss and reduced the staff's administrative workload. The project proved to be technically and economically feasible, utilizing open-source tools that do not require expensive licensing.