Hospital Management System

KOFORIDUA POLYTECHNIC PATIENT MONITORING SYSTEM (A CASE STUDY AT POLYTECHNIC CLINIC, KOFORIDUA) FOR HND COMPUTER NETWORK MANAGEMENT STUDENT’S NAME: WESONO FELIX 04/2010/582D DITSA, JONAS CUDJOE 04/2010/561D DATE: 6TH MARCH, 2013 COMPUTER SCIENCE DEPARTMENT AWARD †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦.. TENTATIVE TITLE (OR FINAL TITLE): †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦ †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦ APPROVED BY HEAD OF DEPARTMENT COMPUTER SCIENCE Signature Date: †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢ € ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦. APPROVED BY DEAN, SCHOOL OF APPLIED SCIENCE AND TECHNOLOGY Signature Date: †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦ Chapter 1 1. 1. INTRODUCTION TO PROJECTHospital administrators are often overwhelmed with information about a bulky number of patients and their stays to the hospital that need to be organized and kept up-to-date. The patient management system is a web based application that is designed and developed for hospital administrators and doctors to organize information on patient visits. The system intends to facilitate several steps in the process from the patient registration and to the patient evaluation. During this process, there will be many tasks that have to be handled by this system including maintaining complete information.The main objective of the system is to provide the administration staff and doctors with an easily maintainable information system for patient registration, visit scheduling and patient tracking with latest information. 1. 2. OBJECTIVES The main objectives for establishing this project is to solve the problem notified in the research. The objectives are outlined as follows: I. To improve patient’s registration II. To increase level of patient management III. To improve on patient records keeping IV. To assign doctors to patients V. Doctor Management VI. Bed/Room ManagementVII. Doctors can update the patient’s record with their observations 1. 3. PURPOSE OF THE PROJECT In a given day, number of patients visits a hospital or a clinic. Many hospitals in Ghana still manage the patient data manually. Hospitals will be able to save money and time if they have a good software program for managing patient’s data. The idea is to develop web based patient management software that can be used to keep track of the patients registering in a hospital or clinic. Doctors and the rooms available in a hospital can be managed using this system.Also, this system should support accessing the previous visit histories of any patient, search for patients by name etc. A few points to be noted about the system we are developing here * A patient can be categorized as â€Å" In patient† or â€Å"Out Patient†. If patient type is â€Å"In Patient†, a bed will be assigned to the patient. * A doctor will be assigned to each patient before the patient meets the doctor. Only one doctor can be assigned to a patient at a given time. * A patient can visit the hospital any number of times The project has been planned to be having the view of distributed architecture, with centralized storage of the database.The application for the storage of the data has been planned. Using the constructs of MS-SQL Server and all the user interfaces have been designed using the ASP. Net technologies. The database connectivity is planned using the â€Å"SQL Connection† methodology. The st andards of security and data protective mechanism have been given a big choice for proper usage. The application takes care of different modules and their associated reports, which are produced as per the applicable strategies and standards that are put forwarded by the administrative staff.The entire project has been developed keeping in view of the distributed client server computing technology, in mind. The specification has been normalized up to 3NF to eliminate all the anomalies that may arise due to the database transaction that are executed by the general users and the organizational administration. The user interfaces are browser specific to give distributed accessibility for the overall system. The internal database has been selected as MS-SQL server 200. The basic constructs of table spaces, clusters and indexes have been exploited to provide higher consistency and reliability for the data storage.The MS-SQL server 200 was a choice as it provides the constructs of high-lev el reliability and security. The total front end was dominated using the ASP. Net technologies. At all proper levels high care was taken to check that the system manages the data consistency with proper business rules or validations. The database connectivity was planned using the latest â€Å"SQL Connection† technology provided by Microsoft Corporation. The authentication and authorization was crosschecked at all the relevant stages. The user level accessibility has been restricted into two zones namely. . 4. PROBLEM IN EXISTING SYSTEM * Cannot Upload and Download the latest updates. * No use of Web Services and Remoting. * Risk of mismanagement of data when the project is under development. * Less Security. * No proper coordination between different Applications and Users. * Fewer Users – Friendly. 1. 5. SOLUTION OF THESE PROBLEMS The development of the new system contains the following activities, which try to automate the entire process keeping in view of the datab ase integration approach. 1. User friendliness is provided in the application with various controls. 2.The system makes the overall project management much easier and flexible. 3. Readily upload the latest updates, allows user to download the alerts by clicking the URL. 4. There is no risk of data mismanagement at any level while the project development is under process. 5. It provides high level of security with different level of authentication. 1. 6. REVIEW OF LITERATURE This chapter is on the related literature of the study and tries to place the study into its theoretical framework. It explores fields of related theories of the study which will serve as the basis for monitoring patients and their records.There is a lot of similar software in the market, example hospital management system which also function the same but it is very complex to use (non-user friendly) and requires a degree of training and expertise before one can use it. With the PATIENT MONITORING SYSTEM, everyth ing is flexible and more user friendly with a high level of security with different level of authentication. 1. 8. BUDGET The budget of the research study will be: ACTIVITY| DURATION| INPUTS/ITEMS REQUIRED| COSTGH| Research| One (1) week| A – 4 paper (3 Rims), laptop| 20. 0| Interviews| One (1)week| | 10. 00| Interface Designer| Five (5 )Days | A- 4 sheets| 10. 00| Data Analysis| One (1)week| | 15. 00| Coding| Two (2) weeks| | 10. 00| Printing & Photocopying| One (1) weeks| A- 4 sheets| 30. 00| Binding | Three (3)Days| | 15. 00| Preparation of final Study Report| Three (3) weeks| | 50. 00| | | SUB TOTAL| 160. 00| | | | | | | TOTAL| 170. 00| | | | | 1. 9. TIMELINE This project is going to be undertaken in two months two weeks to finish the project (PATIENT MONITORING SYSTEM). Hospital Management System KOFORIDUA POLYTECHNIC PATIENT MONITORING SYSTEM (A CASE STUDY AT POLYTECHNIC CLINIC, KOFORIDUA) FOR HND COMPUTER NETWORK MANAGEMENT STUDENT’S NAME: WESONO FELIX 04/2010/582D DITSA, JONAS CUDJOE 04/2010/561D DATE: 6TH MARCH, 2013 COMPUTER SCIENCE DEPARTMENT AWARD †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦.. TENTATIVE TITLE (OR FINAL TITLE): †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦ †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦ APPROVED BY HEAD OF DEPARTMENT COMPUTER SCIENCE Signature Date: †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢ € ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦. APPROVED BY DEAN, SCHOOL OF APPLIED SCIENCE AND TECHNOLOGY Signature Date: †¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦ Chapter 1 1. 1. INTRODUCTION TO PROJECTHospital administrators are often overwhelmed with information about a bulky number of patients and their stays to the hospital that need to be organized and kept up-to-date. The patient management system is a web based application that is designed and developed for hospital administrators and doctors to organize information on patient visits. The system intends to facilitate several steps in the process from the patient registration and to the patient evaluation. During this process, there will be many tasks that have to be handled by this system including maintaining complete information.The main objective of the system is to provide the administration staff and doctors with an easily maintainable information system for patient registration, visit scheduling and patient tracking with latest information. 1. 2. OBJECTIVES The main objectives for establishing this project is to solve the problem notified in the research. The objectives are outlined as follows: I. To improve patient’s registration II. To increase level of patient management III. To improve on patient records keeping IV. To assign doctors to patients V. Doctor Management VI. Bed/Room ManagementVII. Doctors can update the patient’s record with their observations 1. 3. PURPOSE OF THE PROJECT In a given day, number of patients visits a hospital or a clinic. Many hospitals in Ghana still manage the patient data manually. Hospitals will be able to save money and time if they have a good software program for managing patient’s data. The idea is to develop web based patient management software that can be used to keep track of the patients registering in a hospital or clinic. Doctors and the rooms available in a hospital can be managed using this system.Also, this system should support accessing the previous visit histories of any patient, search for patients by name etc. A few points to be noted about the system we are developing here * A patient can be categorized as â€Å" In patient† or â€Å"Out Patient†. If patient type is â€Å"In Patient†, a bed will be assigned to the patient. * A doctor will be assigned to each patient before the patient meets the doctor. Only one doctor can be assigned to a patient at a given time. * A patient can visit the hospital any number of times The project has been planned to be having the view of distributed architecture, with centralized storage of the database.The application for the storage of the data has been planned. Using the constructs of MS-SQL Server and all the user interfaces have been designed using the ASP. Net technologies. The database connectivity is planned using the â€Å"SQL Connection† methodology. The st andards of security and data protective mechanism have been given a big choice for proper usage. The application takes care of different modules and their associated reports, which are produced as per the applicable strategies and standards that are put forwarded by the administrative staff.The entire project has been developed keeping in view of the distributed client server computing technology, in mind. The specification has been normalized up to 3NF to eliminate all the anomalies that may arise due to the database transaction that are executed by the general users and the organizational administration. The user interfaces are browser specific to give distributed accessibility for the overall system. The internal database has been selected as MS-SQL server 200. The basic constructs of table spaces, clusters and indexes have been exploited to provide higher consistency and reliability for the data storage.The MS-SQL server 200 was a choice as it provides the constructs of high-lev el reliability and security. The total front end was dominated using the ASP. Net technologies. At all proper levels high care was taken to check that the system manages the data consistency with proper business rules or validations. The database connectivity was planned using the latest â€Å"SQL Connection† technology provided by Microsoft Corporation. The authentication and authorization was crosschecked at all the relevant stages. The user level accessibility has been restricted into two zones namely. . 4. PROBLEM IN EXISTING SYSTEM * Cannot Upload and Download the latest updates. * No use of Web Services and Remoting. * Risk of mismanagement of data when the project is under development. * Less Security. * No proper coordination between different Applications and Users. * Fewer Users – Friendly. 1. 5. SOLUTION OF THESE PROBLEMS The development of the new system contains the following activities, which try to automate the entire process keeping in view of the datab ase integration approach. 1. User friendliness is provided in the application with various controls. 2.The system makes the overall project management much easier and flexible. 3. Readily upload the latest updates, allows user to download the alerts by clicking the URL. 4. There is no risk of data mismanagement at any level while the project development is under process. 5. It provides high level of security with different level of authentication. 1. 6. REVIEW OF LITERATURE This chapter is on the related literature of the study and tries to place the study into its theoretical framework. It explores fields of related theories of the study which will serve as the basis for monitoring patients and their records.There is a lot of similar software in the market, example hospital management system which also function the same but it is very complex to use (non-user friendly) and requires a degree of training and expertise before one can use it. With the PATIENT MONITORING SYSTEM, everyth ing is flexible and more user friendly with a high level of security with different level of authentication. 1. 8. BUDGET The budget of the research study will be: ACTIVITY| DURATION| INPUTS/ITEMS REQUIRED| COSTGH| Research| One (1) week| A – 4 paper (3 Rims), laptop| 20. 0| Interviews| One (1)week| | 10. 00| Interface Designer| Five (5 )Days | A- 4 sheets| 10. 00| Data Analysis| One (1)week| | 15. 00| Coding| Two (2) weeks| | 10. 00| Printing & Photocopying| One (1) weeks| A- 4 sheets| 30. 00| Binding | Three (3)Days| | 15. 00| Preparation of final Study Report| Three (3) weeks| | 50. 00| | | SUB TOTAL| 160. 00| | | | | | | TOTAL| 170. 00| | | | | 1. 9. TIMELINE This project is going to be undertaken in two months two weeks to finish the project (PATIENT MONITORING SYSTEM).