Design databases to be use in the Sistemas de Información en Salud department, Havana 2021

Abstract

Introduction: the Facultad de Tecnología de la Salud has a database in use for gathering information concerning enrolled students; however, this database does not meet the needs of the department of Sistemas de Información en Salud, it is very important for professors to have a properly information management system helps them for performing the organizational strategies required. Objective: to design a database to be use in the department of Sistemas de Información en Salud for a better information management. Method: an applied research in technological innovation was conducted at the Facultad de Tecnología de la Salud, La Habana, in the period November 2020 - February 2021. A relational database was designed for practical usage. Theoretical and empirical methods were used, including the use of the interview methods focused on obtaining a better description of the department's needs, designing properly through logical and conceptual models the proposed databases. Microsoft Access database engine 2019 was used to build and implemented the databases. Results: the database was developed using the Entity-Relationship model. The entity-relationship diagram and a relational database schema were obtained. By using the Microsoft Access software were built different tables with their respective links, queries, forms and reports. Conclusions: it was designed and implemented a database that satisfies the functional requirements with which the department of Sistemas de Información en Salud will be able to manage its data, in a centralized and efficient manner. The designing and implementation processes of the database were described.

Keywords

• base de datos
• base de datos relacional
• modelo entidad-relación
• gestión de información
• sistemas de información en salud