DEVELOPMENT AND IMPLEMENTATION OF DATABASE MANAGEMENT SYSTEM IN HEALTHCARE CENTERS
Keywords:
Data, DBMS, hospital DBMS system, Simulation model, Simul8, SQL.Abstract
The current research paper describes the development process of relational database management system in one of the private, multidisciplinary, local hospitals of Uzbekistan. Initially the requirements, operation processes, and data recording points of the hospital has been analysed. Following, the relational database has been created using MS SQL server, based on all the requirements found. In the second stage of the research, the operations flow of the Hospital has been modelled in Simul8 tool. Further the end results has been analysed, to find out if the DBMS implementation can really benefit the hospital and improve the operations by removing queues in several bottleneck touchpoints of the hospital.
References
Group, O. (2022). Министерство здравоохранения Республики Узбекистан. Ssv.uz. Available from https://ssv.uz/ru/clinics/12465 [Accessed 31 May 2022]. 2. Tables Relations: One-to-One, One-to-Many, Many-to-Many (2022). Tutorialsteacher.com. Available from https://www.tutorialsteacher.com/sqlserver/tables-relations#many-to-many-relation [Accessed 2 June 2022]. 3. Education, I. (2022). relational-databases. Ibm.com. Available from https://www.ibm.com/cloud/learn/relational-databases#:~:text=correct%20data%20points.-,Benefits,group%2C%20and%20also%20combine%20queries. [Accessed 3 June 2022]. 4. Zhao, L. and Lie, B. (2010). Modeling and Simulation of Patient Flow in Hospitals for Resource Utilization. SNE Simulation Notes Europe, 20 (2), 41-50. Available from 10.11128/sne.20.tn.09976. 5. Teorey, T. (2011). Database modeling and design. Burlington, MA: Morgan Kaufmann.
Downloads
Published
Issue
Section
License
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
