Hospital Management System

KOFORIDUA POLYTECHNIC PATIENT monitor SYSTEM (A CASE STUDY AT POLYTECHNIC CLINIC, KOFORIDUA) FOR HND COMPUTER NETWORK MANAGEMENT educateeS NAME WESONO FELIX 04/2010/582D DITSA, JONAS CUDJOE 04/2010/561D DATE 6TH MARCH, 2013 COMPUTER scholarship discussion section 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 atomic numerate 18 often overwhelmed with information about a bulky fall of patient roles and their stays to the infirmary that need to be organized and kept up-to-date. The patient f arement formation is a web based application that is designed and highly-developed for infirmary administrators and doctors to organize information on patient visits. The constitution intends to facilitate several steps in the process from the patient registration and to the patient evaluatio n. During this process, at that place willing be many tasks that have to be handled by this establishment including master(prenominal)taining complete information.The main objective of the system is to provide the administration staff and doctors with an comfortably maintainable information system for patient registration, visit scheduling and patient tracking with in vogue(p) information. 1. 2. OBJECTIVES The main objectives for establishing this project is to solve the problem notified in the re hunt club. The objectives are outlined as follows I. To improve patients registration II. To increase level of patient trouble III. To improve on patient bear witnesss holding IV. To narrow down doctors to patients V. Doctor Management VI. Bed/Room ManagementVII. Doctors rear update the patients record with their observations 1. 3. PURPOSE OF THE PROJECT In a given day, number of patients visits a infirmary or a clinic. Many hospitals in Ghana still manage the patient data manua lly. Hospitals will be able to surrender m iodiny and time if they have a good software program for managing patients data. The idea is to develop web based patient management software that fag end 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 propagation The project has been planned to be having the view of distributed architecture, with centralized fund of the database. The application for the storage of the data has been planned. Using the constructs of MS-SQL Server and all the exploiter interfaces have been designed using the ASP. Net technologies. The database connectivity is planned using the SQL Connection methodology. The standards of earnest and data protective mechanism have been given a big choice for kosher usage. The application takes care of different modules and their associated reports, which are produced as per the relevant 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 spec has been normalized up to 3NF to eliminate all the anomalies that may arise due to the database transaction that are put to death by the general users and the organizational administration. The user interfaces are browser specific to give distributed accessibility for the overall system. The internal databa se has been selected as MS-SQL server 200. The basic constructs of card spaces, clusters and indexes have been exploited to provide higher accordance and dependability for the data storage.The MS-SQL server 200 was a choice as it provides the constructs of high-level reliability and security. The original 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 current 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 ii zones namely. . 4. PROBLEM IN EXISTING SYSTEM * Cannot Upload and Download the latest updates. * No use of Web operate and Remoting. * Risk of misdirection of data when the project is under development. * less(prenominal) 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 database 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 transfer 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 suppositious 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, everything is flexible and more user friendly with a high level of security with different level of authentication. 1. 8. figure The budget of the research study will be ACTIVITY DURATION INPUTS/ITEMS REQUIRED COSTGH seek mavin (1) week A 4 paper (3 Rims), laptop computer 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 top Three (3)Days 15. 00 Preparation of final Study Report Three (3) weeks 50. 00 SUB arrive 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 MONIT ORING SYSTEM).Hospital Management SystemKOFORIDUA POLYTECHNIC PATIENT MONITORING SYSTEM (A CASE STUDY AT POLYTECHNIC CLINIC, KOFORIDUA) FOR HND COMPUTER NETWORK MANAGEMENT STUDENTS 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 patients 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 patients 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 p rogram for managing patients 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 a nd all the user interfaces have been designed using the ASP. Net technologies. The database connectivity is planned using the SQL Connection methodology. The standards 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 hav e 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-level 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 database 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, everything 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).