pateien information system
IT ELECTIVE 2A – WEB APPLICATION DEVELOPMENT
COURSE PROJECT
2ND SEM 2011- 2012
PROJECT NAME: PATIENT INFORMATION SYSTEM
Project Specifications:
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 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
COURSE PROJECT
2ND SEM 2011- 2012
PROJECT NAME: PATIENT INFORMATION SYSTEM
Project Specifications:
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 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