DESIGN AND IMPLEMENTATION OF COMPUTERISED HOSPITAL DATABASE MANAGEMENT SYSTEM [A CASE STUDY OF IMO STATE UNIVERSITY MEDICAL CENTRE, OWERRI]
ABSTRACT
Clinical database typical contain a significant amount of temporary information. Information is often crucial in medical decision support system. This project involves a careful study of an existing manual system, the designing and implementing a clinical database system, using Imo State University Medical Centre as the case study.
The major areas considered are the General Administrative Unit, the Pharmaceutical unit the Nursing Unit, the Laboratory Unit the Public Health Unit the wards and the medical record unit. With the comprehensive information obtained from the Imo State University Owerri, medical centre and from other different medical sources, I developed a clinical database framework for managing the operations of the clinic.
This software will help a quick access to patient medical records such as patient name, patient diagnosis, prescriptions, drugs dispensed allocation of roads patient’s treatment etc. the software is designed and implemented using Visual Basic 6.0. This scalable system can also be extended to manage larger clinics and relevant computerized health centre.
CHAPTER 1
1.1 INTRODUCTION
Integration of documentation and knowledge based computerized services in information system is a tremendous means of helping health professionals in their daily practices and to improve the quality of service delivery.
Effort is continuously being made in designing and developing economically and reliable database system to satisfy a clinical database information system. This project is about the design and implementation of a clinical database system for clinical management of the IMSU Medical Centre and shows how record and data can be handled and stored within the system.
The system will store patient’s records, drug inventory and dispensation as well as other relevant clinical information within the University Community. The system will be used by the staff (Doctor Nurse, Clerks, Consultants and other relevant authorities as the demand may be) within the clinic. It will process data speedily and accurately provide information when and where required.
The clinical database system will be used to store data produce reports and handle management inquiries. In clinics that are made up of Doctors, Nurse, Patients and other personnel staff, an information system is required to keep track of the day-to-day transaction of the clinic and to improve the communication skills. Also this system will help, in highlighting risk/complex patients for consultant input alert of DNA; easily identify all patients taking certain medications, monitor frequency of major complication e.g. peptic ulcer, check for known drug interaction, and improve evidence based practice, record questions.
Therefore, it is hoped that the design and implementation of a clinical database system would provide a flexible and reliable management of the University clinic. This program is carefully designed to work in a stand alone system or in a multi user environment
1.2 BRIEF HISTORY OF IMO STATE UNIVERSITY MEDICAL CENTER.
The history of IMSU medical center is dated back to 1st of June 1993, with only one Doctor as the medical Director (Dr. Ihekwasu), by 1st of July the same year additional six nurses where employed, subsequently three attendants and Lab technicians where employed. The medical center was started in a one room apartment in the admission block. Later it was moved to its present permanent site, located toward the extreme end of the university campus.
1.3 STATEMENT OF THE PROBLEM
It is observed that in Imo State University Medical Centre, most of its record on staff, students, patients, drug, ward and bed allocation, inventory and drug dispensary are handled manually. The problems associated with the manual method include inaccurate data, poor quality of patient care and administrative inefficiency. The task involved in this design is as follows:
i. Careful study of the manual operations of Imo State University Medical Centre
ii. Collection of information on general problem comforting the medical centre
iii. Study the identified problems, design and develop a clinical database system that will help in solving these problems
iv. Develop computer software that will help in the management of the medical centre
Departments
- Accounting Projects [85]
- Accounting And Management Projects [6]
- Accounting Education Projects [1]
- Adult And Primary Education Projects [6]
- Agricultural And Bio-environmental Engineering Technology Projects [8]
- Agricultural Economics And Extension Projects [57]
- Agricultural Engineering Projects [3]
- Agricultural Technology Projects [1]
- Agriculture Projects [104]
- Agriculture Education Projects [3]
- Anatomy Projects [1]
- Architecture Projects [28]
- Banking And Finance Projects [53]
- Basic Medical Sciences Projects [1]
- Biochemistry Projects [25]
- Biological Sciences Projects [46]
- Biology Education Projects [13]
- Botany Projects [3]
- Building Projects [58]
- Business Administration Projects [151]
- Business Studies Projects [76]
- Chemical Engineering Projects [24]
- Chemistry Education Projects [3]
- Civil Engineering Projects [80]
- Community Health Projects [35]
- Computer Education Projects [6]
- Computer Engineering Projects [28]
- Computer Science Projects [138]
- Construction Engineering And Management Projects [1]
- Cooperative Economics Projects [0]
- Cooperative Economics And Management Projects [2]
- Criminology Projects [68]
- Cyber Security Projects [2]
- Data Science Projects [1]
- Economics Projects [107]
- Economics Education Projects [1]
- Education Projects [189]
- Educational Foundation Projects [9]
- Educational Management Projects [44]
- Electrical/electronics Engineering Projects [140]
- English Education Projects [14]
- English Language Projects [6]
- English Language And Literature Projects [18]
- Entrepreneurship Projects [7]
- Environmental Science Projects [79]
- Epidemiology And Community Health Projects [2]
- Estate Management Projects [40]
- Fashion & Design Projects [1]
- Fine Art Projects [1]
- Food And Nutrition Projects [2]
- Food Science And Technology Projects [52]
- Geography Projects [24]
- Geography Education Projects [4]
- Government And Public Administration Projects [1]
- Guidance And Counselling Projects [132]
- Health Education Projects [9]
- Health Information Management Projects [3]
- History And International Studies Projects [3]
- Human Kinetics And Healthy Education Projects [2]
- Human Resources Management Projects [111]
- Industrial Relations And Personnel Management Projects [58]
- Information And Communication Technology Projects [2]
- Institute Of Education Projects [1]
- Insurance And Risk Management Projects [1]
- International Relations Projects [55]
- Islamic Studies Projects [3]
- Law Projects [21]
- Leisure And Tourism Management Projects [2]
- Library And Information Science Projects [85]
- Linguistics Projects [104]
- Marketing Projects [78]
- Mass Communication Projects [188]
- Mathematics Projects [3]
- Mathematics Education Projects [1]
- Mechanical Engineering Projects [86]
- Medical And Health Science Projects [82]
- Medical Laboratory Science Projects [2]
- Medical Radiography Projects [2]
- Medicine And Surgery Projects [2]
- Metallurgical Engineering Projects [2]
- Microbiology Projects [120]
- Minerals And Petroleum Resources Engineering Projects [32]
- Mining Engineering Techology Projects [2]
- Nursing And Nidwiffery Projects [124]
- Office Technology Management Projects [104]
- Parasitology And Entomology Projects [3]
- Petroleum Engineering Projects [3]
- Pharmacy Projects [18]
- Philosophy Projects [111]
- Physics Projects [3]
- Physiology Projects [1]
- Political Science Projects [123]
- Primary Education Projects [5]
- Project Management Projects [1]
- Psychology Projects [61]
- Psychology Education Projects [1]
- Public Administration Projects [123]
- Public Health Projects [100]
- Purchasing And Supply Projects [112]
- Pure And Industrial Chemistry Projects [8]
- Quantity Surveying Projects [59]
- Science Education Projects [4]
- Science Laboratory Technic Projects [108]
- Science Laboratory Technology (stl) Projects [21]
- Secretarial Administration Projects [40]
- Sex Education Projects [2]
- Social Studies Projects [8]
- Sociology Projects [126]
- Statistics Projects [107]
- Surveying And Geoinformatics Projects [4]
- Theology Projects [9]
- Transportation And Management Projects [3]
- Urban & Regional Planning Projects [1]
- Value Engineering Projects [1]
- Vocational Education Projects [1]
- Zoology Projects [1]