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