We will design - you develop it
This project is different from the other projects we have listed in this site. We want you
to do the project yourself this time. We will provide you the architecture and design of the project.
You have to follow the guidelines and do the development yourself. We believe this is the
best training we can provide you.
Patient Information System (PIS) - Introduction
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 categorised 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 |
Feel free to write your questions and comments as feedback below this page. You can ask any technical
questions and other general comments and we will try to answer all of them.
We will add more information here later...
|
| Author: pratheepa t | Member Level: Bronze | Revenue Score:  |
hi,
As i don't have any practical knowledge about .net coding.Can you please help me out by giving a sample code and please tell how to go about it.
|
| Author: pratheepa t | Member Level: Bronze | Revenue Score: |
hi,
As i don't have any practical knowledge about .net coding.Can you please help me out by giving a sample code and please tell how to go about it.
|
| Author: Padmakumar | Member Level: Gold | Revenue Score: |
po
|
| Author: S.Arul | Member Level: Bronze | Revenue Score: |
hi this is Arul, i just started learning .net could you please tell me how to validate the login form for multiple users.....
|
| Author: Rajeev Kumar Dubey | Member Level: Silver | Revenue Score: |
can you give me basic ado features
|
| Author: Deepa | Member Level: Gold | Revenue Score: |
Hi,
Really good Information
|
| Author: Deepa | Member Level: Gold | Revenue Score: |
Hi,
Really good Information
|
| Author: MaNisH GanGraJ | Member Level: Silver | Revenue Score: |
hi,
this is really good project for basic information.
|
| Author: Satyanarayan SushilKumar Bajoria | Member Level: Gold | Revenue Score: |
Hi,
Really ausum piece of information regarding project on patient information.
Good to start on.
Clearly explain each and every table required to create.
All requirement are clearly mention.
Really very good project.
Keep posting.
Thanks for sharing your knowledge.
And upgrading my knowledge my knowledge.
|
| Author: UltimateRengan | Member Level: Gold | Revenue Score: |
Really nice
|
| Author: mahesh | Member Level: Bronze | Revenue Score: |
Hi,
Its a good project.
|