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, Doctor’s 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 patient’s prescription no longer needed. Patient also will gain advantages from this system because they do not have to spend more time on the process.
Date of Completion
To perform background study on existing clinic management system and the daily process for clinic.
To understand a clinic’s management process and find out the problem for the process.
13 May 2010
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
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
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
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
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
To develop a fully functional system by using suitable development technologies and software.
To create Clinicon Clinic Management System.
18 June 2010
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
To evaluate the system and gather user’s feedback.
To come out a evaluation report about the system and future enhancement.
7 July 2010
To document the completed system.
To create a complete documentation on the system.
9 July 2010
Intel Pentium III processor or equivalent
Intel Dual-Core processor or equivalent
50 MB of free disk space
100 MB of free disk space
LCD Monitor with minimum resolution of
1024 x 768
Widescreen LCD Monitor with minimum
resolution of 1280 x 800
Mouse and Keyboard
Mouse and Keyboard
Graphics Processing Unit
Nvidia GeForce 6 series or above
ATI Radeon HD 2 series or above
10/100 Network Interface Card
10/100/1000 Network Interface Card
Broadband or dial-up internet access
Broadband or dial-up internet access
Color Inkjet Printer
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.
Student’s Signature Supervisor’s Signature
Chapter 1: Background Study
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 patient’s 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 hand’s 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 patient’s records, employee records, medicine records and others.
Functional features and nonfunctional features.
1.3 Summary of Background Study
Chapter 2: Literature Review
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
126.96.36.199 User Interface and process (printscreen of major features)
188.8.131.52 Pros and Cons of the system
1.3.2 Health Watch Pro Clinic Management System
184.108.40.206 User Interface and process()
220.127.116.11 Pros and Cons of the system
2.2 Study on suitable Technologies
2.2.1 Programming Language
18.104.22.168.1 Advantages of using C++
22.214.171.124.2 Limitation of using C++
126.96.36.199.1Java 2 Platform, standard edition 6
188.8.131.52.2 Advantages of using java
184.108.40.206.3Disadvantages of using java
2.2.2 Study on suitable development Software
220.127.116.11.1 Advantages of JCreator
18.104.22.168.2 Disadvantages of JCreator
22.214.171.124.1 Advantages of NetBean
126.96.36.199.2 Disadvantages of NetBean
2.2.3 Study on suitable database Management System (DBMS)
188.8.131.52 Microsoft Access 2007
2.3 Client server architecture
2.3.1What is Client Server Architecture
2.3.2 What is the advantage
Chapter 3: System Analysis
4.1 Fact finding techniques
4.1.1 User requirements
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.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
Average Time Used Without ClicnicOn
Expected Time used With CLinicOn
Patient Waiting Time(according to the number of patient waiting)
Total Time in clinic
Chapter 4: System Design
4.1 System Layouts
4.2 System Design Features
Chapter 5 : Development tools
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
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