Pateien information system

This software can be used to keep track of the patients registering in a hospital or clinic. Also, this system supports accessing the previous visit histories of any patient, search for patients by name and other properties etc. Patient Information System – Requirements

PIS will support registering patients.
Users of this software can search for patients by name, admission date, discharge date etc Users can view the previous visit histories of any patient
System can maintain the list of doctors in the hospital
PIS can maintain the list of beds/rooms available in the hospital Patients are categorized into “In Patients” and “Out Patients” Designing the Patient Information System

The first step is to identify the different entities in the system. The following entities are identified in our PIS :
Patient – a patient is the person who visit the hospital for treatment/consultation Doctor – a doctor will be assigned to each patient.
Bed – if patient type is “In Patient”, a bed will be assigned to the user. Visit – a patient can visit the hospital any number of times. Database design

You can choose SQL Server or MS Access as the database for this project.

Let us design a table corresponding to each entity so that we can save those entities.

Table Name : Patient

When a new patient arrives in a hospital and register, we will add a record to this table. A patient will have only one record in this table.

Fields :
Field Name
Type
Id
Auto Number
Name
varchar (50)
Address
varchar (255)
DateOfBirth
DateTime
Phone
varchar (20)
EmergencyContact
varchar (255)
DateOfRegistration
DateTime

Table Name : Doctor

This is a master table, where we maintain the list of all available doctors in the hospital.

Fields :
Field Name
Type
Id
Auto Number
Name
varchar (50)
Address
varchar (255)
Phone
varchar (20)

Table Name : Bed

This is a master table where maintain the list of all beds (rooms) in the hospital. Before we start assigning a bed to a patient, we must have created all available beds in the hospital.

Fields :
Field Name
Type
Id
Auto Number
BedName
varchar (50)
RatePerDay
Number
BedType
varchar (50)

Table Name : Visit

This is a detail table where we create a record for each visit of each patient.

Fields :
Field Name
Type
Remarks
Id
Auto Number

PatientType
Number
0 – In patient, 1 – Out Patient
DoctorId
Number
For each visit, a doctor will be assigned to the patient.
BedId
Number
If the patient type is “In Patient”, a bed will be assigned to the user. DateofVisit
DateTime
The date on which the patient visited the hospital
DateofDischarge
DateTime
Date on which patient is discharged from the hospital. If the patient type is “Out Patient”, DateofDischarge will be same as DateofVisit Symptoms
varchar (1000)
The symptoms of the patient
Disease
varchar (1000)
Disease identified by the doctor.
Treatment
varchar (1000)
Treatment suggested by the doctor.

Symptoms, Disease and Treatment are sensitive information. In most of the cases, this information will not be saved into Patient Information System. You can remove those fields if you don’t them to be part of the system.

User Interface design

We need the following screens:
Screen
Details
Patient List
This screen uses a data grid to display the list of registered patients. User can enter the partial name of a patient to filter the list of patients by name. Also, it should be possible to filter patients by DateofRegistration. Patient Registration

This screen allows to add/edit patient registration
Patient Visits
This screen uses a data grid to display the list of patient visits. This screen can be filtered by patient name, date of visit, date of discharge etc. Patient Visit
This screen allows to add/edit patient visits
Doctors List
This screen displays the list of all available doctors, using a datagrid Edit Doctor
Add/Edit doctors
Bed List
This screen uses a datagrid to display the list of all available beds in the hospital. Edit Bed
Add/Edit bed information

Leave a Reply
Your email address will not be published.
*
*

BACK TO TOP