Development Of Clinic Management System Computer Science Essay

Development Of Clinic Management System Computer Science Essay Nowadays most of the clinic in Malaysia is using semi-systematic software to handle their daily activities. Doctor still need to write the symptom and prescription manually using paper and pen hence pass it to nurse for further process like recording, preparing and payment. This project known as ClinicOn is to develop a Clinic Management System exclusively designed to help all kind of clinic including traditional Chinese medicine clinic and western medicine clinic. ClinicOn offers modules for management of client information including history, Doctors appointments, administrative activities, billing and report. User will able to acces to different level of content based on the types of user log in. there are 3 types of user in the system which is doctor, staff and administrator. Doctor is valid to edit all the information of the user and access to database. Staffs are just able to edit the information of patients and store. Besides that, doctor is able to write prescription on the system while staffs are not allowed. Lastly, the administrator is able to log in too get full control on the system and edit the content and index in the database. Apart from the standard features of other clinic management software, ClinicOn is develop by considering the end user in mind. ClinicOns ease of use, multiuser functionality and manageability are exemplary compared to other. This system will be written in Java language using NetBean and the data will handle by a database in order to ensure all the clients can share the information or data that store in the server. The database will be created using MySQL language and will use the MySQL Connector/J in order to build the java application that can interact with MySQL. The fully systematic software will able to benefits doctors, staffs and clients. Doctors are able to get benefits from this system because the manual activities like writing the patients prescription no longer needed. Patient also will gain advantages from this system because they do not have to spend more time on the process. Objectives No Objectives Date of Completion 1 To perform background study on existing clinic management system and the daily process for clinic. To understand a clinics management process and find out the problem for the process. 13 May 2010 2. To determine a few possible solutions for the existing problem in the existing system and existing process. To come out with a report illustrating the best approaches to solves existing problems. 15 May 2010 3. To perform background study on similar clinic management system and compare the features between those systems. To determine the benefits and limitation of the similar system and produce a study report based on the study. 17 May 2010 4. To perform literature review on technologies and software that suitable for system development. To generate a report on suitable technologies that use to develop the system. 21 May 2010 5. To perform system analysis and determine the system requirements that need to be included in the new system. To generate a series of system analysis report and features in the system. 2 June 2010 6. To design the overall flow of the new system based on fact-finding from system analysis phase. To build the logical model and flow chart. 13 June 2010 7. To develop a fully functional system by using suitable development technologies and software. To create Clinicon Clinic Management System. 18 June 2010 8. To perform testing on the system and solve the possible problem, bugs. To ensure the system is working perfectly and error-free. 1 July 2010 9. To evaluate the system and gather users feedback. To come out a evaluation report about the system and future enhancement. 7 July 2010 10 To document the completed system. To create a complete documentation on the system. 9 July 2010 System requirement Hardware requirement Minimum Requirement Recommended Requirements Intel Pentium III processor or equivalent Processor Intel Dual-Core processor or equivalent 128 MB Memory 1GB 50 MB of free disk space Hard Disk 100 MB of free disk space CD-ROM Drive Optical Drive DVD-ROM Drive LCD Monitor with minimum resolution of 1024 x 768 Display Devices Widescreen LCD Monitor with minimum resolution of 1280 x 800 Mouse and Keyboard Input Devices Mouse and Keyboard Integrated Graphics Graphics Processing Unit Nvidia GeForce 6 series or above ATI Radeon HD 2 series or above 10/100 Network Interface Card Network Devices 10/100/1000 Network Interface Card Broadband or dial-up internet access Internet Connectivity Broadband or dial-up internet access Normal Printer Miscellaneous Color Inkjet Printer Software Requirements: Operating System Microsoft Windows XP SP 2 and above. Mac OS X 10.5.5 and above. Ubuntu Linux(Any versions) Java Runtime Environment Java SE Runtime Environment 6 and above. Students Signature Supervisors Signature ____________________ _______________________ Date: Date: Chapter 1: Background Study Introduction This chapter provides an introduction to and outline of the rest of the background study. This chapter made a background study on 2 existing similar system to define the advantages, disadvantages of those system. the advantages will be taken and disadvantages will be avoid to create a better version of ClinicOn Clinic Management system. The similar system that chooses to analysis are Vet Sys DB-Clinic Management System and Health Watch Pro Clinic Management system. This two system are free ware that used by small size clinic and popular with the simple and efficient function. Study on general clinic operation system and process. 1.2.1General operating process of clinic. The general operating process for small size clinic nowadays is most on manual and very troublesome. When the patient process to the clinic, the nurse and staff have request patients name or patient identification card number in order to get the full records of the patient. The patients records is stored manually by alphabets from A-Z or the years of birth of the patient according to the patient identification card number. After the records of patient is found, the nurse will put the patient records in the waiting place and wait for the doctor to attend the patient. If the patient is new and never visit the clinic before, the nurses will present the patient a registration form. After patient completely fill in the registration form, nurse will fill in the new patient to a new patient records form and lastly put the patient records into waiting place. The doctor will get the patient records that in the waiting place and start diagnosis the patient. the patient records will contain all information that needed by the doctor. after the doctor consult the patient, the doctor have to write prescription and decide the medicine for the patients. The prescription and medicine name will write in a paper manually. After the doctor finish consults the patient, the patient records which included the newest prescription will be hands up to nurse or staff to collect the medicine and lastly payment process will be conducted. Nurses have to record down the medicine that sole and deduce manually from the total of the medicine records. After the payment, the patient records will be placed according to categories either by alphabets or Identification card number. The nurse will be able to get the patient records easily every time the patient visits the clinic again. 1.2.2 Problem of existing general clinic management system The process above is wasted lots of time. The time will be taken a lots when a nurse need to record the patients information from the patient registration form lastly just can put the patient in the waiting place. It is wasted time by doing the same things in two times. Besides that, lots of time also be used up when a nurse want to search a patient through categories by categories manually. after the doctor finish the prescription nurse have to reduce the total amount of the medicine manually from the medicine record and lastly payment by type in the total and required information for the payment receipt. Beside of wasting the time, it also require large physical storage to store all the hard copy patients records, employee records, medicine records and others. 1.2.3 Solution Functional features and nonfunctional features. 1.3 Summary of Background Study Chapter 2: Literature Review 2.1 Introduction This chapter led the author to determine the suitable technologies that available that will be used to create the ClinicOn Clinic Management System. In this chapter, the author had made some studies on Programming language like java and C++, the developing software like JCreator, Visual Basic and NetBean. Beside that there are also some comparison between those studies and thus define the benefits and limitation of each technologies. After the studies, the author had chose the best and suitable technologies and software to develop the ClinicOn Clinic Management System. 1.3 Study on similar system 1.3.1 Vet Sys DB- Clinic Management System 1.3.1.1 User Interface and process (printscreen of major features) 1.3.1.2 Pros and Cons of the system 1.3.2 Health Watch Pro Clinic Management System 1.3.2.1 User Interface and process() 1.3.2.2 Pros and Cons of the system 2.2 Study on suitable Technologies 2.2.1 Programming Language 2.2.1.1C++ 2.2.1.1.1 Advantages of using C++ 2.2.1.1.2 Limitation of using C++ 2.2.1.2Java 2.2.1.2.1Java 2 Platform, standard edition 6 2.2.1.2.2 Advantages of using java 2.2.1.2.3Disadvantages of using java 2.2.2 Study on suitable development Software 2.2.2.2 JCreator 2.2.2.2.1 Advantages of JCreator 2.2.2.2.2 Disadvantages of JCreator 2.2.2.3NetBean 2.2.2.3.1 Advantages of NetBean 2.2.2.3.2 Disadvantages of NetBean 2.2.3 Study on suitable database Management System (DBMS) 2.2.3.1 Microsoft Access 2007 2.2.3.2MySQL 2.3 Client server architecture 2.3.1What is Client Server Architecture 2.3.2 What is the advantage Chapter 3: System Analysis 3.1 Introduction 4.1 Fact finding techniques 4.1.1 User requirements 4.1.2 Observation 3.2 system requirement 3.3 Use case diagram 4.3 Logical Models 4.3.1 Class Diagram 4.3.2 relationship for Class Diagram 4.4 Flowcharts 4.4.1 Overall Flowchart 4.4.2 Login Module Flowchart 4.4.3 Password Recovery Flowchart 4.4.4 Main Module Flowchart 4.4.5 Performance Flowchart 4.4.6 Time Improvement Process Measured(maximum) Average Time Used Without ClicnicOn Expected Time used With CLinicOn Intake Process 25Mins 5Mins Patient Waiting Time(according to the number of patient waiting) 20Mins 10 Mins Clinic Services 30 Mins 20mins Payment 20 mins 5 Mins Total Time in clinic 95 mins 40 mins Chapter 4: System Design 4.1 System Layouts 4.2 System Design Features Chapter 5 : Development tools 5.1 JCreator 5.1.1 Advantages 5.1.2 Disadvantages 5.1 Netbeans 5.1.2 Advantages 5.1.3 Disadvantages 5.2Netbeans IDE vs Jcreator 5.2 MySQL Query Brower vs Command Prompt Chapter 6 System Development Chapter 7 : System Testing 7.1 Performance testing 7.2 Error handling testing 7.2 compatibility testing 7.4 security testing Chapter 8 system Evaluation Evaluation Criteria Evaluation Result System output User interface System engine Summary of system evaluation Chapter 8 conclusion Chapter 9 references Chapter 10 appendixes A Gantt Chart B1 Project Monitoring Report C sample of Questionaire Form D Sample of Evaluation Form E Print Screen F Source Code