COMSATS University Islamabad
Attock campus
Project Title
Your name:
Reg name:
Accepted by:
Date:
2
TABLE OF CONTENTS
Chapters
CHAPTER I: INTRODUCTION
1.1 Problem Identification
1.2 Description of Exisiting System
1.3 Evaluation of Existing Solutions
1.4 Description of Proposed System
1.5 Evaluation of Proposed Solutions
1.6 Plan of Action
CHAPTER II: SYSTEM DESIGN & DEVELOPMENT
2.1 Hardware and Software Requirements
2.2 Design
2.3 Development
CHAPTER III: TESTING
3.1 Testing Strategy
3.2 Test Results
CHAPTER IV: DOCUMENTATION
4.1 User Documentation
4.2 Technical Documentation
CHAPTER V: SYSTEM DEVELOPMENT & EVALUATION
5.1 Evaluation of the Proposed System
5.2 Further Development
3
4
CHAPTER I: INTRODUCTION
1.1 Problem Identification
In the existing system, the manual process, receiving data’s from Doctor’s and Patient’s details
are done through manual records. These records are entered in manual process. In this process
will take long time, separate workers need to maintaining the databases. All the clinical details
are stored via separate databases. It will take long time due to this process time waste, money
waste etc...This process is very difficult to maintain the record of each patient in proper way.
1.2 Description of Existing System
The existing Clinical management system consist of hand written files, registers etc. The whole
record of Clinic like Patient information, Doctor information , labortery details, is saved in hand
written form. It is handled by Admin Block of Hospital. It is totally manual work that all type of
information is stored in hand written form. . In the existing system chances of errors are more
and more because calculation are done manually so there is more chances of errors. Time
consumption is much more in this existing system of Clinic management. In the existing system
a lot of problems occur because all the records are maintaining in the files/registers. The
existing system is not user friendly because retrieval of data is much difficult in the existing
system. The data cannot maintain easily in the existing system. As all the record is maintained
in the registers/files so loss off even a single page leads to difficulty .In the middle of the session
when administrator wants to view the list of those patients who do not come for checkup this
month then he needs to calculate the number of patients and number of months patient does
not come for checkup etc.. On every page of a register which shows that it is much complex
5
operation which can be performed manually . The output if the system is not faster and if we
want to access the historical data then it will take a lot of time and in some cases it is not
possible.
So the existing system is
> Not user-friendly
> Difficulty in calculation
> Lots of paper work
> Manual control
> Time consuming
1.3 Evaluation of Existing Solutions
The existing system has some solution these solutions are categorized into different types like
manual solution , Ms Access is the one possibility also or the electronically stored system is the
solution of the existing system. If we use manual solution then there may be a burden of
employees because we need to hire employees for each register to maintain the record of
students and teachers. If we use manual solution then time complexity will also increase
because there is wastage of time when u want to search the,
record of anyone. Loss of even single register cause big problem and there is no solution of this
in case if you loss a register. so we ignore this solution because our purpose is not solved .
Computer stored system is also the possible solution of maintaining record. If we use Ms-
6
Access then we can save record by creating different fields and the record can be saved
efficiently. But using this way the data cannot be saved for a long time and there is no security
of this software and anyone who uses the computer can access the data of any one. So the
purpose of creating such software which have some security and work efficiently doesn’t full fill
using Ms Access .One else option to save and search record efficiently is to create the database
and save the record using database. If we use database to computerize the tradition way of
Clinic management then it has some advantages that are the data can easily saved ,the data can
easily be modified, the data can easily be searched and the data can easily be deleted without
much wastage of time so Using this option we can fulfill our purpose to create an efficient and
secure software.
1.4 Description of Proposed System
This system provides the detail structure of the clinic and different departments. CMS
synchronizes the working of all the departments. It looks on all aspects of a clinic, its patients,
doctors, Departments and other activities. CMS is the easiest way to manage all functionalities
of a clinic, which facilitates clinics to maintain the functionality related to clinic employees and
their patients.
Benefits:
Following are the benefits for using Clinic Management System :
For Employees:
● Easy to create any kind of patient Certificate i.e medical certificate.
● Easy to query all related details of Patient and Doctor.
7
● Easy to generate payroll of individual employee in the clinic.
For Clinic:
● Collective records of patients of all departments.
● Collective records of employees of all departments.
● Easy approach to find the detail information for any patient/doctor/employee.
● Easy to handle all functionality of Clinic.
● Easy to manage all actions (giving advance appointment, patient report etc).
● All information can be synchronized in one place. And distribute to a particular
department to management properly.
● CMS is beneficial for both patients/doctors only in the way that they can get all
previous or current information’s when they need.
● It is helpful to maintain the patients record (medical test record, operation record,
tablets record etc).
Advantages :
● By using this software, you can learn how you prepare your records in standard manner.
● By using this software, administrator can manage all records in standard manner.
● Also it can help to get all or a particular patient medical test information by laboratory
master.
● Also it can help to maintain the fees and accounting reports of clinic in proper way.
● It helps to generate sheets of current year or previous year's patients.
8
1.5 Evaluation of Proposed Solutions
The main objective of the existing system is to provide a user-friendly interface. The system,
which is proposed, now computerizes all the details that are maintained manually. Once the
details are fed into the computer there is no need for various persons to deal with separate
sections. Only a single person is enough to maintain all the reports. The security can also be
given as per the requirement of the user
⮚ Large volumes of data can be stored with case.
⮚ Maintenance of file is flexible.
⮚ Records stored are updated now and then.
⮚ Stored data and procedures can be easily edited.
⮚ Reports can be generated with case.
⮚ Accurate calculations are made.
⮚ Less manpower required.
1.6 Plan of Action
Once we examine that out project is feasible, we start the project planning. First of all we need
to select data base tool that we use to create a proposed system then we create tables of our
project because this will be the first requirement of our database project .If we done this step
successfully then the ERD of our project will be generated automatically. After the generation
of ERD we need to create the design of our database which act as a graphical user interface. In
this phase we need to create design by using different modules first we create design on front
9
end, behind this there is coding for different forms. We will create the login screen for our
project then we will create different forms like main menu, including interphase of all form for
user then there is requirement of
query form so that user can easily retrieve the specific data. After these all steps we create
report form so that the admin can get the report on time without much time consuming. After
doing all these steps we need to test our project that weather it is working according to
requirement or not. We will follow waterfall model throughout our project as in this model we
can’t goes to next phase until the first phase is complete i.e. we perform analysis of our project
then we will design our data base After designing we will implement our management system
and at the end we will test our software by using different strategies like applying validations
rules of different fields. These all steps are a part of project plan.
10
11
CHAPTER II: SYSTEM DESIGN & DEVELOPMENT
2.1 Hardware and Software Requirements
Hardware Requirements:
The hardware used for the development of the project is:
PROCESSOR : PENTIUM III 866 MHz
RAM : 512 MD SD RAM (minimum)
MONITOR : 15’’ COLOUR
HARD DISK : 20 GB
CD DRIVE : LG 52X
KEY BOARD : 120 Keys STANDARD
MOUSE : 3 BUTTONS
Software Requirements:
Operating System: Windows 98/XP/window’s7/windows 8’s
Additional software: MS Word (Documentation tool)
Front End: MS Access 2013/VB
Backend: MS ACCESS 2013
12
2.2 Design
In this phase we will show the database design i.e. the application design and selection of
database for project. Database design is most important in a project.
Data flow existing (in place) solutions:
After a detailed description given above it is important to put the “Existing (in place) Solutions”
in perspective. The dataflow diagram or DFD(s) shown below aid in doing so and then the
evaluation of the existing (in place) solutions will follow.
DFD Of Proposed Project:
13
ERD Of Proposed System:
14
Design View:
15
Table Tbl_Doctor:
Table Tbl_doctor_patient:
16
Table Tbl_labortary:
17
Table Tbl_login:
18
Table Tbl_patient:
19
Table Tbl_pharmacy:
20
Table Tbl_Rooms:
21
Table Tbl_schedule:
22
Table Tbl_staff:
23
2.3Development
General Features:
24
⮚ This button has been used to show last record.
⮚ This button shows the previous record.
⮚ This button is used to delete any specific record.
⮚ This button is used on all the forms .its purpose is to add new record.
⮚ Instead of last record it will show the next record.
⮚ This button will show the last record.
⮚ This button is used in all forms and it is used for go to back menu..
A.SYSTEM ARCHITECHTURE:
The Clinic Management Information
System (CMIS) is composed of independent software
components developed using different proprietary and
non-proprietary web development tools. Application
software and data are hosted by different cloud service
25
providers that offer free Infrastructure as a Service (IaaS).
This design is based on Service-oriented Architecture (SOA)
as utilized by in constructing
hospital-wide systems. Using any modern browser like Google
Chrome, Firefox, Opera, Safari, and IE10, the user can access
the clinic website which can also serve as the Clinic
Information System Portal (CISP) that can launch the
different sub-systems for doctor, research, extension,
and physical facilities. The website content
administrator can add, edit, delete, and deactivate links to the
different information systems of the clinic. In the CMIS, the
following information systems have been defined and can be
launched by the CISP: Doctor Information Management
System (DIMS), Research Information Management System
(RIMS), Extension Information Management System
(EIMS), Physical Facilities Information Management System
(PFIMS). Thru the links in the main page, authorized users
can access the different clinic information system web
pages and respective databases being hosted by different
cloud service providers. The system architecture of CMIS is
designed as described in Fig. 1.
B.SOFTWARE:
26
The software was designed such that anybody with
internet access using modern browsers can visit the website
of the clinic to view general information such as its mission,
vision and objectives, clinic officials, contact details and
history of the clinic, important announcements, recent and
past events or activities of the clinic, and significant
captured moments in the picture gallery.
27
28
CHAPTER III: TESTING
3.1 Testing Strategy
In testing strategy we perform some task to evaluate our proposed system.
Tbl_doctor:
Test No; Field Name Sample Data Expected Result Actual Result
1 NAme 312 Error generate Error generate
2 NAme 12345 Error generate Error generate
3 NAme Dr Nayer Accepted Accepted
Mehmood
4 DoctorID Error generate Error generate
5 DoctorID 1 Accepted Accepted
Tbl_patient:
Test No; Field Name Sample Data Expected Result Actual Result
1 Name 1234 1 1
2 Name Anwar Zeb Accepted Accepted
Tbl_login:
Test No; Field Name Sample Data Expected Result Actual Result
1 password 50143 Error generate Error generate
2 password 1234 Accepted Accepted
3.2 Testing Results
3.3 Tbl_doctor
For test number 1.2
Error message generated
29
As in the name field we enter only alphabets.
For test number 4.
Tbl_patient:
For test number 1
Tbl_login:
For Test no; 1
Error Generated
30
31
CHAPTER IV: DOCUMENTATION
4.1 User Documentation
The main purpose of user documentation is to describe how user can use the different features
of proposed system.
First user open the MS Access file and then a login form appear. In this form user must enter
user id and a password. There is a type of users, which is “Admin”.
If we enter invalid user id or password then error message show on screen.
If password is valid then user can access the main menu. i.e
“Well come to Shifa International Islamabad clinical management System”.
32
Form Main Manu:
Now by Clicking on Buttons, the following Forms are Open. The Form’s which are as;
The Main form having different buttons for other forms that have to be open for different
purpose.
Doctor Form:
33
Patient Form:
The patient form having the detail of each patient and also having different buttons for specific
operations.
Labortary Form:
34
Pharmacy Form:
35
Rooms Form:
Schedule Form:
36
Staff Form:
Queries of each table:
Doctor Query:
37
Labortery Query:
Pharmacy Query:
38
Rooms Query:
Schedule Query:
39
Staff Query:
Report of Each Table:
40
Doctors Report:
Labortery Report:
Patient Report:
41
Pharmacy Report:
Rooms Report:
42
Staff Report:
43
4.2 Technical Documentation
Technical documentation for clinic management database. This project can be manufactured on
7th Jan 2016.
This product have the memory storage of 10 GB.
This product can be operated by the latest version of MS Access 2007 or 2013.
This software can be operated on window 7 /vista/win 8.
This product have no need of internet connection.
Main View of Ms Access:
Open the MS ACCESS and click on new the new project will be open.
44
Creating Tables:
First click on create then click the table and name the table the above window will appear. Then
name the specific file.
Creating Queries:
45
First Click on Create and then click query design the above window will appear. Then name the
specific file.
Creating Reports:
Click on create then click on report design the above window will be appear. Then name the
specific file.
Creating Forms:
46
First click on create then click on form design the above window will appear. Then name the
specific file.
47
48
CHAPTER V: SYSTEM DEVELOPMENT & EVALUTION
5.1 Evaluation of the Proposed System
The main objective of the existing system is to provide a user-friendly interface. The system,
which is proposed, now computerizes all the details that are maintained manually. Once the
details are fed into the computer there is no need for various persons to deal with separate
sections. Only a single person is enough to maintain all the reports. The security can also be
given as per the requirement of the user
⮚ Large volumes of data can be stored with case.
⮚ Maintenance of file is flexible.
⮚ Records stored are updated now and then.
⮚ Stored data and procedures can be easily edited.
⮚ Reports can be generated with case.
⮚ Accurate calculations are made.
⮚ Less manpower required.
5.2 Further Development
In future if project on clinical management system is given then with the passage of time and
also due to new demand of people many things can be change in the project. If the person is
provided with each equipment of project then first of all the login system of the project will be
on figure print, eye retina scanner etc. The design of forms, reports and queries can also be
changed with the demand of People. The Graphics can also be inserted into the project.
49
