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