Modelado de bases de datos para un sistema de recopilación de proyectos de voluntariado comunitario como complemento a la iniciativa de responsabilidad social empresarial de una compañía de telecomunicaciones en Colombia

Abstract

This project proposes the design of a relational database model to organize and centralize information related to corporate volunteering projects of a telecommunications company in Colombia. The main problem identified was the dispersion of data across multiple formats, which hindered traceability, evaluation, and impact measurement of these initiatives. The project followed a structured technical methodology across six phases: needs diagnosis, requirements analysis, conceptual design, logical design, physical design, and model evaluation. Entities such as projects, activities, volunteers, intervention zones, participation, feedback, and documents were defined, applying normalization principles, data retention policies, and aligning with ISO/IEC 12207 and 25012 standards.The model enables historical traceability, assessment of social impact, and supports the future development of a robust information system. A 10-year data growth projection was made, showing no need for a complex infrastructure. While the system was not implemented, the model offers a solid technical foundation for future deployment.