PROJECT REPORT

HOSPITAL MANAGEMENT SYSTEM

BY
(your name>

Enrollment No. 20******

Under Guidance

Of

****Guide name*****

Submitted to the School of Computer and Information Sciences

In partial fulfilment of the requirements
For the degree of

Bachelor
Of
Computer Applications

Indira Gandhi National Open University

Maidan Garhi

New Delhi – 110068

Page | 1
 Index
Topic Page number

1. Project Introduction 3
2. Project Objective 4
3. Overall Description 7
4. Feasibility study 11
5. Tools and environment 14
6. Tabular Structure 16
7. Data Flow Diagram 30
8. ER Diagram 34
9. Form Description of Project 35
10. User Interface Design 36
11. Project Coding 46
12. Hardware and Software Requirement 186
13. Future scope of hospital Management System 187
14. Software Testing 188
15. Scope of Further Application 190
16. Limitation of Project 190
17. Bibliography 191

Page | 2
The software is for the automation of hospital management. It maintains two levels of users: -
Administrator level
User level
The software includes: Maintaining patient details. Providing prescription, Precautions and Diet
advice. Providing and maintaining all kinds of tests for a patient. Billing and Report Generation.
it can be used any Hospital, Clinic, Dispensary or pathology labs for maintaining. Patient details and
their test results. Fully networked based and will be managed by the latest technology tools. Software
will be easy to use and fully graphical interface will be provided to the end user. This software make
will make your hospital ‘WPP’ that means without paper & pen.

NEED FOR SYSTEM DEVELOPMENT

Since the existing system as totally manual has a lot of complexities, shortcoming in it self and all the
data was being store in registers, files etc. and keeping in mind the above limitation of the existing
system, to overcome these limitations the new computerized system was needed, so that information
can have provided to the users more easily, more quickly and more accurately.

Page | 3
Project is related to Hospital Management System. The project maintains two levels of users: - .
Administrator Level-Doctor
. User Level-Data Entry Operator
The hospital, intending to meet the medico social needs of various communities of different economic
status, has been obliged to adjust its various services/facilities of general nature and teaching to the
present requirements of the society in North India. The broad objectives of the 500 bedded
multidisciplinary teaching hospitals are cited below:

I. To provide comprehensive health care, encompassing preventive, primitive, curative and

rehabilitative health care to the residents of North India drawn from the urban/semi-urban and
rural areas.

ii. To provide out-patient, in-patient and round the clock maternity and emergency care
services of all basic and supportive general specialties. These services would be provided free
to the poor whereas the more affluent component of the society will add gradually to the
government revenue.
iii. To provide round the clock facilities of intensive care unit, coronary care unit, burns unit
and neonatal intensive care unit.
iv. To provide the Main facilities available in this project are:

. Maintaining records of indoor/outdoor patients.

. Maintaining patient’s diagnosis details, advised tests to be done.

. Providing different test facilities to a doctor for diagnosis of patients.

X-Ray
Urine Test
Stool Test
Sonographer Test
Gastroscopy Test
Colonoscopy Test
Blood Test
Biochemistry Test

Page | 4
 . Maintaining patient’s injection entry record.
. Maintaining patient’s prescription, medicine and diet advice details. .
Providing billing details for indoor/outdoor patients.
. Maintaining backup of data as per user requirements (between mentioned dates).
. If user forgets his/her password, then it can be retrieved by hint question.

In this project collection of data is from different pathology labs Result of tests, prescription,

Precautions and diet advice will be automatically updated in the database. Related test report,

Patient details report, prescription and billing report can be generated as per user requirements.

User or Administrator can search a patient’s record by his/her name or their registration date.

Patient’s diet advice can be provided in Hindi.

v. ct as a free medical institution for direct/first level contact for patients and also as a secondary
level referral center for the referred cases from nearby smaller/large hospitals
(Government/private), health centers, polyclinics and dispensaries situated in North India.

vi. To act, specifically, as a regional overflow multi-disciplinary institution (north region) for
the referred cases by linking horizontally with other peripheral 100 bedded and 500 bedded
general hospitals in the north, with other major teaching institutions and larger multidisciplinary
hospital situated in other parts of Chandigarh.

vii. To reduce considerably the present workload of other hospitals, especially the Postgraduate
Institute of Medical Education & Research, Chandigarh and thereby offer maximum relief to
the economically weaker section and middle section of the people residing in rural and
semiurban areas of Chandigarh.
viii. To participate in various national health programs, including National Family Welfare
Programed, by linking with various Government/private hospitals and health centers
Page | 5
 (horizontally and vertically) and providing necessary infrastructure and facilities as per their
demands.

ix. To fulfill the glaring deficiency of an undergraduate Medical College in the Union
Territory of Chandigarh which offers the best educational facilities in all other fields. The
Government Medical College will be attached to the teaching hospital.
x. To act as a center for Continuing Medical Education Programs for various categories of
technical and non-technical personnel of different disciplines working within and from other
various sized hospitals.
xi. To render facilities for conducting research activities relating to different specialties, as and
when required.
xii. Last but not the least the hospital, as a measure for future expansion, in response to the changing
trend in hospital services, would also provide facilities/services (clinical, diagnostic,
therapeutic) of various other specialties in future depending upon the real needs of the
population.

Page | 6
Goals of proposed system:

1. Planned approach towards working: - The working in the organization will be

well planned and organized. The data will be stored properly in data stores, which will
help in retrieval of information as well as its storage.

2. Accuracy: - The level of accuracy in the proposed system will be higher. All operation
would be done correctly and it ensures that whatever information is coming from the
center is accurate.

3. Reliability: - The reliability of the proposed system will be above stated reasons. The
reason for the increased reliability of the system is that now there would be proper
storage of information.

4. No Redundancy: - In the proposed system utmost care would be that no information

is repeated anywhere, in storage or otherwise. This would assure economic use of storage
space and consistency in the data stored.

5. Immediate retrieval of information: - The main objective of proposed system

to provide for a quick and efficient retrieval of information any type of information
would be available whenever the requires.

6. Immediate storage of information: - In manual system there are many problems

to store the largest amount of information.

7. Easy to operate: The system should be easy to operate and should be such that it can
be developed within a short period of time and fit in the limited budget of the user.

Page | 7
Background: - A hospital is a place where patients come up for general disease. Hospitals provide

facilities like: -

 Consultation by Doctors on Disease.

 Diagnosis for disease.
 Providing treatment facility.
 Facility for admitting patients (providing beds, nursing medicines etc.)  Immunization for
patients/children.
Various optional works that are done in a Hospital are: - 
Recording information about the patients that come.
 Generating bills.
 Recording information related to diagnosis given to patients.
 Keeping record of the immunization provided to children/patients.
 Keeping information about various disease and medicines available to cure them.
These are the various jobs that need to be done in a Hospital by the operational staff and Doctors. All
these works are done on papers.
The work is done as follows: -
 Information about Patients is done by just writing the Patients name, age and gender. Whenever the
Patient comes up his information is stored freshly.
 Bills are generated by recording price for each facility provided to Patient on a separate sheet and at
last they all are summed up.
 Diagnosis information to patients is generally recorded on the document, which contains patient
information. It after some time period to decrease the paper load in the office.
 Immunization records of children are maintained in pre-formatted sheets, which are kept in a file.
 Information about various diseases is not kept as any document. Doctors themselves do this job by
remembering various medicines.

All this work is done manually by the receptionist and other operational staff and lot of papers are needed
to be handled and taken care of. Doctors have to remember various medicines available for diagnosis
and sometimes miss better alternatives as they can’t remember them at that time.

Page | 8
User Characteristics:
Every user should be:

• Comfortable of working with computer.

• He must have knowledge in medical field.

• He must also have basic knowledge of English too.

Constraints:
• GUI is only English.

• Login and password is used for identification of user and there is no facility for guest

Definitions of problems:
Problems with conventional system

1. Lack of immediate retrievals: - The information is very difficult to retrieve and find

particular information like-E.g.-To find out about the patient’s history, the user has to go through

various registers. This results in inconvenience and wastage of time.

2. Lack of immediate information storage: - The information generated by various

transactions takes time and effort to stored at a right place.

3. Lack of prompt updating: - Various changes to information like patient details or

immunization details of child are difficult to make as paper work is involved.

4. Error prone manual calculation: - Manual calculations are error prone and take a lot of time

this may result in incorrect information. For example, calculation of patient’s bill based on various

treatments.

5. Preparation of accurate and prompt reports: - This becomes a difficult task as

information is difficult to collect from various registers.

Page | 9
Alternative Solutions: -

1. Improved Manual system: - one of the alternative solutions is the improvement of

the manual system. Anything, which can be done by using automated methods, can be done

manually. But the question arises how to perform thing manually in a sound manner.

Following are some suggestions, which can be in the manual system. A more sophisticate

register maintenance for various patient information, Doctor diary, immunization Details and a

good system for writing bill amount employees and stock availed for the customer can be

maintained at central place. Adequate staff may be maintained so that pupations are made at

the very moment at the time. Proper person for proper work be made responsible so that a

better efficiency could be achieved. This needs a lot of work force.

2. Batch System: - Another alternative solution can be used of computer based batch

system for maintaining the information regarding purchase details, customers and employees.

A batch system refers to a system in which data is processed in a periodical base. The batch

system is able to achieve most of the goals and sub goals. But a batch system data is processed

in sequential basic. Therefore, batch system is not suggested.

3. Online System: - this system (HMS) provides online storage/updates and retrieval

facility. This system promises very less or no paper work and also provides help to Doctors

and operational staff. In this system everything is stored electronically so very less amount of

paper work is required and information can be retrieved very easily without searching here and

there into registers. This system is being discussed here.

Page | 10
Depending on the results of the initial investigation the survey is now expanded to a more detailed

feasibility study. “FEASIBILITY STUDY” is a test of system proposal according to its workability,

impact of the organization, ability to meet needs and effective use of the resources. It focuses on these

major questions:

1. What are the user’s demonstrable needs and how does a candidate system meet them?

2. What recourses are available for given candidate system?

3. What are the likely impacts of the candidate system on the organization?

4. Whether it is worth to solve the problem?

During feasibility analysis for this project, following primary areas of interest are to be considered.

Investigation and generating ideas about a new system does this.

Steps in feasibility analysis

Eight steps involved in the feasibility analysis are:

 From a project team and appoint a project leader.

 Prepare system flowcharts.

 Enumerate potential proposed system.

 Define and identify characteristics of proposed system.

 Determine and evaluate performance and cost effective of each proposed system.

 Weight system performance and cost data.

 Select the best-proposed system.

 Prepare and report final project directive to management.

Page | 11
 Technical feasibility:
A study of resource availability that may affect the ability to achieve an acceptable system. This evaluation
determines whether the technology needed for the proposed system is available or not.
* Can the work for the project be done with current equipment existing software technology &available
Personal?
* Can the system be upgraded if developed?
* if new technology is needed then what can be developed?
This is connected with specifying equipment and software that will successfully satisfy the user
requirement. The technical needs of the system may include:

Front-end and back-end selection:

An important issue for the development of a project is the selection of suitable front-end and back-end.
When we decided to develop the project we went through an extensive study to determine the most
suitable platform that suits the needs of the organization as well as helps in development of the project.

Front-end selection:
1. It must have a graphical user interface that assists employees that are not from IT background.
2. Scalability and extensibility.
3. Flexibility.
4. Robustness.
5. According to the organization and the culture.
6. Must provide excellent reporting features with good printing support.
7. Platform independent.
8. Easy to debug and maintain.
9. Event driven programming facility.
10.Font end must support some popular back end like SQL-SERVER.
According to the above stated features we selected VB.NET-2008 as the front-end for developing our
project.

Back-end Selection:
1. Multiple user support.
2. Efficient data handling.
3. Provide Inherent features for security.
4. Efficient procedures.
5. Popularity.
6. Operating system compatible.
7. Easy to install.
8. Various drives must be available.
9. Easy to implant with the Front-end.

According to above stated features we selected SQL-SERVER as the backend.

The technical feasibility is frequently the most difficult area encountered at this stage. It is essential
that the technical feasibility. It centers on the existing computer system (hardware, software etc.) and
to what extent it can support the proposed the system.
Page | 12
 Economical feasibility:
Economic justification is generally the “Bottom line” consideration for most systems. Economic
justification includes a board range of concerns that includes cost benefit analysis. In this we weight
the cost and the benefits associated with candidate system
And if it suits the basic purpose of the organization i.e. profit making, the project is making to the
analysis and design phase.
The financial and the economic questions during the preliminary investigation are verified to estimate
the following:
• The cost to conduct a full system investigation.
• The cost of hardware and software for the class of application being considered.
• The benefits in the of reduced cost.
• The proposed system will give the minute information; as a result, the performance is improved
which in turn be expected to provide increased profits.
• This feasibility checks whether the system can be developed with the available funds. This Hospital
Management doesn’t require enormous amount of money to be developed. This can be done
economically if planned judicially, so it is economically feasible. The cost of project depends upon
the number of man-hours required.

Operational Feasibility:
It is mainly related to human organization and political aspects. The points to be considered are:
• What change will be brought with the system?
• What organization structures are disturbed?
• What new skills will be required? Do the existing staff members have these skills? If not, can they
be trained in due course of time?
The system is operationally feasible as it very easy for the End user to operate it. It only needs basic
information about windows platform.

Schedule feasibility:
Time evaluation is the most important consideration in the development of project. The time schedule
required for the developed of this project is very important since more development time effect machine
time, cost and cause delay in the development of other systems.

A reliable Hospital Management system can be developed in the considerable amount of time.

Page | 13
Supported Tools Are

• ASP.NET WITH C# (As Front –End Tool)

• SQL SERVER (As Back –End Tool)
Supported Operating Systems

• Windows NT/2000
• Windows 95/98
• Sun Solaris 2.6/2.7
• HP-UX
• IBM AIX
• Compaq Tru64
• Linux

Internet Information Server (IIS) – Internet Information Server supports the core web server
functionality.

.NET Framework – .NET is a framework that covers all the layers of software development from the
operating system up. It provides the richest level of integration among presentation technologies,
component technologies and data technologies. The entire architecture has been created to make it as
easy to develop Internet applications, as it is to develop for the desktop environment.

C#.NET – C#.NET is the language used to build classes, retrieve and manipulate data, and handle
events.

ASP.NET – ASP.NET is the .NET framework layer that handles Web requests for specific types of
files, namely those with .aspx and. acsx extensions. The ASP.NET engine provides a robust object
model for creating dynamic content and is loosely integrated into the .NET framework. This
integration makes it easy to change the implementation when the .NET framework migrates to
platform other than Windows. ASP.NET supports all the .NET languages (currently C#, VB.NET, and
Jscript, but there are well over 20 languages in development for .NET).

Hypertext Markup Language (HTML) – HTML is a formatting /Layout language used to design the
user interface.

Page | 14
JavaScript – JavaScript programming language is used to manipulate page objects within a client
browser.

Extensible Markup Language (XML) – XML is a general–purpose markup language used

throughout Visual Studio and .NET as a way to hold and manipulate data retrieved from a database; a
format for specifying application configuration information; a way to persist data and objects; and a
generic data container for passing messages, objects and data from one component or tier to another.

SQL Server 2005 - SQL server 2005 is one of the leading RDBMS software in the world. It is
characterized by the quick retrieval of information from huge tables. This quality allows it to cater to
the ever-changing business needs of the present age.

HARDWARE USED

Processor : Intel dual-core inside

Memory : 1GB RAM.

Network Adapter : Ethernet Adaptor

Modem : 56kbps Voice Fax Data

Secondary Storage : Dell Hard disk (160 GB)

Page | 15
Table Number: -01
Table Name: -Login

FIELD NAME TYPE DESCRIPTION

USER_NAME VARCHAR
PASSWORD VARCHAR
USERTYPE VARCHAR

Table Number: - 02
Table Name: - Patient Detail Table

FIELD NAME TYPE DESCRIPTION

REGISTRATION_NO VARCHAR
REGISTRATION_DATE DATE/TIME
NAME VARCHAR
ADDRESS VARCHAR
CITY VARCHAR
TELEPHONE_MOBIL_NO VARCHAR
MARITAL_STATUS VARCHAR
REIGION VARCHAR
GENDER VARCHAR
FATHER_HUSBAND_NAME VARCHAR
STATUS VARCHAR INDOOR/OUTDOOR
AGE INTEGER

Table Number: - 03
Table Name: - Patient Diagnosis Table

FIELD NAME TYPE DESCRIPTION

DIGNOSIS_NO VARCHAR
REGISTRATION_NO VARCHAR
DIGNOSIS_DATE DATE/TIME

Page | 16
PROVISIONAL_DIGNOSIS VARCHAR
REMARK VARCHAR
BIOCHEMISTRY VARCHAR
STOOL VARCHAR
BLOOD VARCHAR
COLONOSCOPY VARCHAR
GASTROSCOPY VARCHAR
URINE VARCHAR
XRAY VARCHAR
SONOGRAPHY VARCHAR
OTHERS VARCHAR
RECONSULTATION_ADVICE_WE VARCHAR WEEK WISE
EK
RECONSULATION_ADVICE_DATE DATE/TIME
ECG VARCHAR

Table Number: - 04
Table Name: - Patient Diet Advice Table

FIELD NAME TYPE DESCRIPTION

DIGNOSIS_NO VARCHAR
DIET_ADVICE VARCHAR

Table Number: - 05
Table Name: - Patient Medicine Table

FIELD NAME TYPE DESCRIPTION

DIGNOSIS_NO VARCHAR

MEDICINE_NO INTEGER

MEDICINE_NAME VARCHAR

PRECAUTION VARCHAR

PRECAUTION VARCHAR MEDICINE RELATED HINDI

WORDS
NO_OF_DOSES INTEGER

Page | 17
Table Number: - 06
Table Name: - Patient Injection Dates Table

FIELD NAME TYPE DESCRIPTION

DIGNOSIS_NO VARCHAR
INJECTION_DATE DATE/TIME
STATUS VARCHAR INJECTION TAKEN OR NOT

Table Number: - 07
Table Name: - Biochemistry Test Table

FIELD NAME TYPE DESCRIPTION

REGISTRATION_NO VARCHAR

TEST_DATE DATE/TIME

GLUCOSE_FASTING_R VARCHAR 70-110 MG %

TWO_HR_PG_PP VARCHAR <100 MG %

BLOOD_UREA VARCHAR 10-40 MG %

CREATININE VARCHAR 0.6-1.5 MG %

S_CHOLESTEROL VARCHAR 130-250 MG %

TOTAL_PROTEIN VARCHAR 6.0-8.0 GM %

ALBUMIN VARCHAR 3.5-5.0 GM %
GLOBWLIN VARCHAR 2.3-3.6 GM%
A_G_RATIO VARCHAR ?1.5:,-2.3:1
GAME_GT VARCHAR 11-50 UL
ALKALINE_PTASE VARCHAR 10-90 U/L ADULT
BILIRUBIN_INDIRECT VARCHAR 0.0-0.8 MG %

BILIRUBIN_TOTAL VARCHAR 0.0-0.6 MG %

SGOF VARCHAR 0.2-1.0 MG %
SGPT VARCHAR 0-40 U/L
HALF_HR_PG_PP VARCHAR 0-40 U/L
ONE_HR_PG_PP VARCHAR <110 MG %
Page | 18
 URINE_SUGAR1 VARCHAR
URINE_SUGAR2 VARCHAR
URINE_SUGAR3 VARCHAR
URINE_SUGAR4 VARCHAR
ACID_PTASE VARCHAR
GLUCOSE_R_PP VARCHAR
T3 VARCHAR 0.3-2.5 UI U/L
T4 VARCHAR 4.5-12 UI U/L
TSH VARCHAR 0.4-4/0 UI U/L
ONE_AND_HALF_PG_PP VARCHAR <160 MG %
BUN VARCHAR <140 MG %
HLD_CHOLESTEROL VARCHAR 8-20 MG %
LDL_CHOLESTEROL VARCHAR 30-55 MG %
VLDL_CHOLESTEROL VARCHAR 60-165 MG %
TRIGLYCERIDES VARCHAR 0-60 MG%
S_TOTAL_LIPIDS VARCHAR 0-60 MG%
S_AMYLASE VARCHAR 400-700 MG %
S_LIPASE VARCHAR 25-125 U/L
SODIUM VARCHAR 8-54 UG/L
POTASSIUM VARCHAR 136_146MEQ/L
CHLORIDE VARCHAR 94-111 MMO I/L
CALCIUM VARCHAR 8.5-11.0 MG/DI
LDH_TOTAL VARCHAR 230-461 U/L
CK_NAK_ACTIVATED VARCHAR 0-190 U/L
CK_MB_NAC_ACTIVATED VARCHAR <12 U/L
URIC_ACID VARCHAR 4-6 MGDI

Table Number: - 08
Table Name: - Blood Test Table
FIELD NAME TYPE DESCRIPTION
REGISTRATION_NO VARCHAR
TEST_DATE DATE/TIME
HAEMOGLOBIN VARCHAR 13-15 GSM%
TLC VARCHAR 4500-10500 CELLS/CUMM
NEUTROPHILS VARCHAR DLC,45-68%
LYMPHOCYTES VARCHAR DLC,25-45%
EOSINOPHIL VARCHAR DLC,2-6%

Page | 19
MONOCYTES VARCHAR DLC,1-4%
BASOPHILS VARCHAR DLC,1-2%
OTHERS VARCHAR DLC
ESR VARCHAR 0-10 MM IST HR
PERIPHERAL_BLOOD_FILM_1 VARCHAR
PERIPHERAL_BLOOD_FILM_2 VARCHAR
HAEMATOCRIT_PCV VARCHAR
TOTAL_RBC VARCHAR MIL/C.MM
PLATELETS VARCHAR CU.MM
COLOUR_INDEX VARCHAR
MCHC VARCHAR
MCV VARCHAR F1
MCH VARCHAR PG
TEC VARCHAR CU.MM
VEC VARCHAR
PARACYTES VARCHAR
BLOOD_GROUPING VARCHAR
RH_FACTOR VARCHAR
RH_ANTIBODY_TILER VARCHAR

Page | 20
DIRECT VARCHAR
INDIRECT VARCHAR
PLASMA_FIBRINOGEN VARCHAR 150-400 MG%
HIV VARCHAR
HBSAG VARCHAR
WIDAL VARCHAR
FOETAL_ESHAEMOGLOBIN VARCHAR
RETICULOCYTES VARCHAR
BLEEDING_TIME_MIN VARCHAR
BLLEDING_TIME_MIN VARCHAR
CLOTING_TIME_MIN VARCHAR
CLOTING_TIME_SEC VARCHAR
PROTHROMBIN_TIME_CONTROL VARCHAR
SECS_PATIENT_1 VARCHAR
SECS_PATIENT_2 VARCHAR
PTTK_CONTROL VARCHAR
HAEMOLYSIS_START_FROM VARCHAR
SALINE_COMPLETE_AT VARCHAR
CLOT_RETRACTION_TIME_CRT VARCHAR
LE_CELLS VARCHAR
ESR_PLATELETS VARCHAR

Table Number: - 09
Table Name: -Colonoscopy Test Table

FIELD NAME TYPE DESCRIPTION

REGISTRATION_NO VARCHAR
TEST_DATE DATE/TIME

Page | 21
 ANAL_CANAL VARCHAR
RECTUM VARCHAR
SIGMID_COLON VARCHAR
DESCENDING_COLON VARCHAR
SPLENIC_FLEXURE VARCHAR
TRANSVERSE_COLON VARCHAR
HEPATIC_FLEXURE VARCHAR
ASCENDING_COLON VARCHAR
CAECUM VARCHAR
TERMINAL_ILEUM VARCHAR
BIOPSY VARCHAR
OPINION_1 VARCHAR
OPINION_2 VARCHAR
BILIARY_REFLUX VARCHAR
GUT_HYPOMOTILITY VARCHAR
OPINION_SECOND VARCHAR

Table Number: - 10
Table Name: - Gastroscopy Test Table
FIELD NAME TYPE DESCRIPTION
REGISTRATION_NO VARCHAR
TEST_DATE DATE/TIME
ESOPHGUS VARCHAR ESOPHGUS
FUNDUS VARCHAR STOMACH
CORPUS VARCHAR STOMACH
ANTRUM VARCHAR STOMACH
BLUB VARCHAR DEUODENUM
FIRST_PART VARCHAR DEUODENUM
SECOND_PART VARCHAR DEUODENUM
BIOPSY VARCHAR
OPINION_FIRST VARCHAR
PYLOROSPASM VARCHAR

Table Number: - 11

Page | 22
Table Name: -Sonography Test Table
FIELD NAME TYPE DESCRIPTION
REGISTRATION_NO VARCHAR
TEST_DATE DATE/TIME
L_SIZE VARCHAR LIVER
L_ECHOTEXTURE VARCHAR LIVER
FOCAL_PATHOLOGY VARCHAR LIVER
IHBR VARCHAR LIVER
PV VARCHAR LIVER
CBD VARCHAR LIVER
G_SIZE VARCHAR GALL BLADDER
WALL_THICKNESS VARCHAR GALL BLADDER
LUMEN VARCHAR GALL BLADDER
P_SIZE VARCHAR PANCREAS
P_SHAPE VARCHAR PANCREAS
P_ECHOTEXTURE VARCHAR PANCREAS
S_SIZE VARCHAR SPLEEN
S_SIZE VARCHAR SPLEEN
S_SHAPE VARCHAR SPLEEN
S_ECHOTEXTURE VARCHAR SPLEEN
K_SIZE_RT VARCHAR KIDNEYS
K_SIZE_LT VARCHAR KIDNEYS

Page | 23
K_SHAPE_RT VARCHAR KIDNEYS
K_SHAPE_LT VARCHAR KIDNEYS
K_CORTEX_RT VARCHAR KIDNEYS
K_CORTEX_LT VARCHAR KIDNEYS
K_CORTICOMEDULLARY_DIFFEREN VARCHAR KIDNEYS
TIATION_RT
K_CORTICOMEDULLARY_DIFFEREN VARCHAR KIDNEYS
TIATION_LT
K_PCS_RT VARCHAR KIDNEYS
K_PCS_LT VARCHAR KIDNEYS
K_CALCULUS_RT VARCHAR KIDNEYS
K_CALCULUS_LT VARCHAR KIDNEYS
AORTA VARCHAR PETROPERITONNEAL
STRUCTURES
IVC VARCHAR PETROPERITONNEAL
STRUCTURES
PRE_PARAORTIC_LYMPHADENOPA VARCHAR PETROPERITONNEAL
THY STRUCTURES
FLIID_IN_PERITONEAL_CAVITY VARCHAR PETROPERITONNEAL
STRUCTURES
VISUALISED_BOWEL VARCHAR PETROPERITONNEAL
STRUCTURES
U_STATUS VARCHAR URINARY BLADDER
U_WALL_THICKNESS VARCHAR URINARY BLADDER
U_CALCULUS VARCHAR URINARY BLADDER
PREVOID_URINARY_VOL VARCHAR URINARY BLADDER
POSTVOID_URINARY_VOL VARCHAR URINARY BLADDER
PR_SIZE VARCHAR PROSTATE
PR_ECHOTEXTURE VARCHAR PROSTATE
PR_CAPSULE VARCHAR PROSTATE
U_SIZE VARCHAR UTERUS
U_POSITION VARCHAR UTERUS
U_ECHOTEXTURE VARCHAR UTERUS
U_E_CAVITY VARCHAR UTERUS

Page | 24
 U_ENDOMETRIUM VARCHAR UTERUS
O_SIZE_RT VARCHAR OVARIES
O_SIZE_LT VARCHAR OVARIES
O_SHAPE_RT VARCHAR OVARIES
O_SHAPE_LT VARCHAR OVARIES
O_ECHOTEXTURE_RT VARCHAR OVARIES
O_ECHOTEXTURE_LT VARCHAR OVARIES
O_ADENEXAL_MASS_RT VARCHAR OVARIES
O_ADENEXAL_MASS_LT VARCHAR OVARIES
FREE_FLUID_IN_POUCH_DOUGLAS VARCHAR OVARIES
IMPRESSION VARCHAR
MECROPHAGES VARCHAR MICOSCOPIC
TROPHOZOITE VARCHAR PARASTIES
P_OVA VARCHAR PARASTIES
P_CYST VARCHAR PARASTIES
C_OVA VARCHAR CONCENTRATION METHOD
C_CYST VARCHAR CONCENTRATION METHOD
OCCULT_BLOOD VARCHAR SPECIAL TEST
PH VARCHAR SPECIAL TEST
RED_SUB VARCHAR SPECIAL TEST

Table Number: - 12
Table Name: -Stool Test Table
FIELD NAME TYPE DESCRIPTION
REGISTRATION_NO VARCHAR
TEST_DATE DATE/TIME
COLOR VARCHAR PHYSICAL
MUCUS VARCHAR PHYSICAL
BLOOD VARCHAR PHYSICAL
WBC_HBF VARCHAR MICOSCOPIC
RBC_HPF VARCHAR MICOSCOPIC

Table Number: - 13
Page | 25
 PORPHOBILINOGEN VARCHAR SPECIAL_TEST
ACETONE VARCHAR SPECIAL_TEST
OCCULT_BLOOD VARCHAR SPECIAL_TEST
PKU VARCHAR SPECIAL_TEST
BECE_JONES_PROTEINS VARCHAR SPECIAL_TEST
AMINO_ACID VARCHAR SPECIAL_TEST
24HRS_URINARY_PROTEIN VARCHAR SPECIAL_TEST
24HRS_URINARY_17_KETOSTER VARCHAR SPECIAL_TEST
IOD
24HRS_URINARY_VMA VARCHAR SPECIAL_TEST
TOTAL_VALUE VARCHAR SPECIAL_TEST
PREGNANCY_TEST VARCHAR SPECIAL_TEST
Table Name: - Urine Table
FIELD NAME TYPE DESCRIPTION
REGISTRATION_NO VARCHAR
TEST_DATE DATE/TIME
APPEARANCE VARCHAR ROUTINE
SP_GRAVITY VARCHAR ROUTINE
REACTION VARCHAR ROUTINE
ALBUMIN VARCHAR ROUTINE,MG%

SUGAR VARCHAR ROUTINE

RBCS_HPE VARCHAR MICROSCOPIC
WBCS_HPF VARCHAR MICROSCOPIC
EPITH_CELLS_HPF VARCHAR MICROSCOPIC
CAST_HPF VARCHAR MICROSCOPIC
AMORPHOUS_SEDIMENTS VARCHAR MICROSCOPIC
SPERMATOZOA VARCHAR MICROSCOPIC

OTHERS VARCHAR MICROSCOPIC

BILE_SALT VARCHAR SPECIAL_TEST

BILE_PIGMENT VARCHAR SPECIAL_TEST
UROBILINOGEN_HPF VARCHAR SPECIAL_TEST

Table Number: - 14
Table Name: -Usg Table
Page | 26
PORT1 VARCHAR
PAN VARCHAR
PAN1 VARCHAR
SPLE VARCHAR
SPLE1 VARCHAR
KIDN VARCHAR
KIDN1 VARCHAR
KIDN2 VARCHAR
RK VARCHAR
LK VARCHAR
BOTH VARCHAR
BOTH1 VARCHAR
URIN VARCHAR
URIN1 VARCHAR
N VARCHAR
N1 VARCHAR
UTER VARCHAR
LONG VARCHAR
ANTE VARCHAR
TRAN VARCHAR
N3 VARCHAR
ADNE VARCHAR
OTH VARCHAR
ECHO VARCHAR
FIELD NAME TYPE DESCRIPTION
REGISTRATION_NO VARCHAR
TEST_DATE DATE/TIME
LIV VARCHAR
LIV1 VARCHAR
LIV2 VARCHAR
GALL VARCHAR
GALL1 VARCHAR
COMM VARCHAR
COMM1 VARCHAR
PORT VARCHAR

Table Number: - 15
Table Name: -X-Ray Table
FIELD NAME TYPE DESCRIPTION

Page | 27
X_RAY_NAME VARCHAR
REMARKS_1 VARCHAR
REMARKS_2 VARCHAR
REMARKS_3 VARCHAR
REMARKS_4 VARCHAR
REMARKS_5 VARCHAR
REMARKS_6 VARCHAR
REMARKS_7 VARCHAR
REMARKS_8 VARCHAR
REMARKS_9 VARCHAR
REMARKS_10 VARCHAR
REMARKS_11 VARCHAR
OPINION VARCHAR
REGISTRATION_NO VARCHAR
TEST_DATE DATE/TIME

Table Number: - 16
Table Name: - X-Ray Values Table
FIELD NAME TYPE DESCRIPTION
X_RAY_NAME VARCHAR
REMARKS_1 VARCHAR
REMARKS_2 VARCHAR
REMARKS_3 VARCHAR
REMARKS_4 VARCHAR
REMARKS_5 VARCHAR
REMARKS_6 VARCHAR
REMARKS_7 VARCHAR
REMARKS_8 VARCHAR
REMARKS_9 VARCHAR

Table Number: - 17

Page | 28
REMARKS_10 VARCHAR

REMARKS_11 VARCHAR

OPINION VARCHAR

Table Name: -Patient Free Table

FIELD NAME TYPE DESCRIPTION
RECEIPT_NO VARCHAR

REGISTARTION_NO VARCHAR
RECEIPT_DATE DATE/TIME
F_TOTAL_FEES INTEGER TOTAL FEES IN FIGURE
W_TOTAL_FEES INTEGER TOTAL FEES IN WORDS
RECEIPT_NAME INTEGER SELF/CHEQUE
DIGNISIOS_FEES INTEGER
XRAY_FEES INTEGER
ECG_FEES INTEGER
LAB_TEST_FEES INTEGER
GASTROSCOPY_FEES INTEGER
UCG_FEES INTEGER
INDOOR_INJECTION_FEES INTEGER
COLONOSCOPY_FEES INTEGER

Page | 29
DATA FLOW DIAGRAMS
DFD: LEVEL 0

Page | 30
Page | 31
DFD: LEVEL 1

Page | 32
DFD: LEVEL2

Page | 33
Page | 34
FORM DESCRIPTION OF PROJECT
User interface design has a much to do with the study of people as it does with technology
issues. Here we represent some interface designs depicted in figures.

FORM NAME FORM DESCRIPTION

login.aspx User /Admin login id

Home.aspx Home page of the project.
patient entry form .aspx This is add patient entry form
PRescription entry form.aspx It is allow to prescription entry form
patient dignosis history form.aspx It is patient history form
INJection.aspx It is patient injection detail show
patient receipt entry form.aspx It is patient receipt form details

patient receipt qury form.aspx It is patient query form details

Biochemistory test.aspx It is boichemistory test entry form
colonoscopy test.aspx It is colonoscopy test entry form

gastroscopy.aspx It is gastroscopy test entry form

Blood Test form.aspx It is Blood test entry form
Stoll test form.aspx It is Stoll test entry form
Sonography test form.aspx It is Sonography test entry form
X-ray Form.aspx It is X-ray test entry form
Urine test form.aspx It is X-ray test entry form
Test Report.aspx It is test report form
search by name form.aspx This patient name search details
Search by date form.aspx This patient date search deatis

Page | 35
User Interface design: -
The different interfaces are: -

Login page:

Home page:

Page | 36
Patient Entry Form:

Prescription Entry Form:

Page | 37