Context Diagram For Victoria Hospital System Nursing Essay

‘ Victoria Hospital has 15 General Practitioners (GPs) and approximately 15,000 patients. It has 5 reception staff, a number of nursing staff, who carry out minor procedures at the surgery.

‘ A team of district nurses, who visit patients in their homes.

‘ When patients join the surgery they are allocated to one of the GPs, however they may make an appointment to see any of the GPs.

‘ At an appointment a GP may prescribe many treatments for the patient.

‘ The surgery also processes repeat prescriptions and runs a number of clinics, such as Baby Care, Asthma and Diabetes.

Top Level Data Flow Diagram for Victoria Hospital System

Process Description

Process No. : 1.1

Process Name : Appointment Process.

Activity : Providing basic information about patient

: Providing time schedule of GP

: Providing an appointment and cash receipt to patient

Process No. : 1.2

Process Name : Treatment Process.

Activity : Providing further information about patient.

: Providing treatment particulars for the patient.

Process No. : 1.3

Process Name : Clinic Process.

Activity : Providing clinic details.

Process No. : 1.4

Process Name : Final Payment Process.

Activity : Providing final payment for entire surgery.

Dataflow Description

1.1 Appointment Process

When a patient comes to consult a GP (General Practitioner) for surgery, firstly, he/she should make an appointment. Therefore, a patient provides his basic information to the system, and the system gets time schedules from the GPs for meet the patient. If the patient pays the appointment fee, the system will make and provide appointment and cash receipt to the patient.

1.2 Treatment Process

In this process, the system asks further information of the patient, and GP examines the patient and enters his/her health situation to the system. The system will ask treatment particular about the patient and also GP provide it. The nurse asks the system to know the particular of patient’s treatment and the system provides it.

1.3 Clinic Process

The GP provides clinic dates to the system for a patient. And the nurses check the clinic dates and time to do a clinic properly. It includes the home visit too.

1.4 Final Payment Process

Finally, the system processes the total payment of the entire surgery, and makes an invoice. The patient provides the final payment for surgery.

Data Store Content

In Patient file

Patient ID, Patient’s name, Sex,

Patient’s contact number, Date & time of appointment, Age,

Initial complain, GP ID, Treatment ID,

Clinic name, Date & time of clinics, Payment ID

will be stored. In this file Patient ID is taken as a primary key. GP ID, Treatment ID and Payment ID are taken as foreign key.

In Work Schedule File

GP ID, GP’s name, GP’s contact number, Available date and time

of consult the patients

will be stored. In this file GP ID is taken as a primary key.

In Treatment file

Treatment ID, Diseases/disorders/symptoms, Medical diagnosis,

Treatment type

will be stored. In this file Treatment ID is taken as a primary key.

In Payment file

Payment ID, Patient ID, Patient’s name, Appointment fee, Treatment Fee , Medicines fee

will be stored. In this file Payment ID is taken as a primary key. Patient ID is taken as foreign key.

External Entity Definitions

Patient

Patient is an external entity in this Victoria Hospital System. Patients should make an appointment to consult the GP for surgery procedure. After that the GP will examine the patient and prescribe many treatments and drugs. Patient has to pay for appointment and final payment of surgery procedure.

GP (General Practitioner)

GP (General Practitioner) is another external entity in this Victoria Hospital System. GP has many surgery appointments in a day. The GP diagnoses the patient completely and then prescribes treatments.

Nurse

Nurse is another external entity in this Victoria Hospital System. They assist in the surgery procedure with the GP and do the treatments. A team of district nurses visit patients’ home. And also runs number of clinics such as Baby Care, Asthma and Diabetes.

Entity Relationship Diagram for Victoria Hospital System

Entity Relationship Diagram with Attributes

Entity Description for an Entity Relationship Diagram

Entity name : Patient

Activities : Make an appointment.

: Do payments.

: Provide information about his/her current health

condition.

: Take treatments according to the GP prescriptions.

Entity name : Surgery Appointment

Activities : Provide an appointment to patient.

: Get surgery information about patient.

: Get GP’s information.

: Provide surgery information of patient to the GP and

the Nurse.

Entity name : GP (General Practitioner)

Activities : Examine the patient.

: Diagnose the problem.

: Do treatments.

Entity name : Nurse

Activities : Do treatments.

: Do home visits.

: Run clinics.

Entity name : Treatment

Activities : Provide treatments.

: Provide drugs.

Entity name : Clinic

Activities : Provide treatments.

: Provide drugs.

Appropriate Attributes for All Entities in the Victoria Hospital System

Patient :

Primary Key – PatientID

Surgery Appointment :

Primary Key – AppointmentID | Foreign Key – PatientID & GPID

GP :

Primary Key – GPID

Nurse :

Primary Key – NurseID

Treatment :

Primary Key – TreatmentID | Foreign Key – AppointmentID & ClinicID

Clinic :

Primary Key – ClinicID | Foreign Key – TreatmentID, AppointmentID & NurseID

Relationship between Entities in Victoria Hospital System

Between Patient and Surgery Appointment

In this relationship, a Patient has to take a Surgery Appointment. This relationship called as one to one relationship. It is Mandatory.

As well as a Surgery Appointment has a Patient. This is also one to one relationship. It is also mandatory.

Between Surgery Appointment and the GP

In this relationship, a Surgery Appointment has a GP. This is a one to one and mandatory relationship.

And also a GP has a Surgery Appointment. It is called one to many relationship and it is mandatory.

Between Surgery Appointment and Nurse

In this relationship, a Surgery Appointment may have many Nurses. This relationship is called one to many relationship and it is optional. Optional mean by zero or more

Between Surgery Appointment and Treatment

In this relationship, a Surgery Appointment may have many treatments. It is too one to many relationship and it is optional.

Between Treatment and Clinic

In this relationship, zero or many Treatments have zero or many Clinics. Like this zero or many clinics have zero or many treatments. This relationship called as many to many relationships and it is optional.

Between Nurse and Clinic

Finally, one or more Nurses may run zero or more Clinics. This relationship called as many to many relationships. It is optional but partly.

System Development Process for the Victoria Hospital System

GANTT CHART

Strengthens Of the Proposed Victoria Hospital System

‘ Faster and efficient in processing of appointment procedure.

‘ Automatic generation of documents like invoices, Patients’ Reports.

‘ With the larger reductions in the cost of hardware and software and availability of user-friendly software package, it is relatively cheaper like maintaining a manual system.

‘ More timely information can be produced.

‘ No more manual processing of the data- all automatically been posted to the various ledgers/accounts and many types of useful reports can be generated for management to make decisions.

Future Implementation of the System

‘ Implement and include the Management Information System

‘ Implement and include the Accounting Information System

‘ Establish the Network System in the Hospital

‘ Implement the Drugs Control System

‘ Develop the statistical details about the Hospital

‘ Develop the Hospital Website for online registration, e-channeling etc.

CONCLUSION FOR THE PROJECT OF VICTORIA HOSPITAL SYSTEM

The project Victoria Hospital System (VHS) is for computerizing the working in a hospital. The system takes care of all the requirements of an average hospital and is capable of provide easy and effective storage of information related to patients who come up to the hospital.

It generates the appointment sheet; provide prescription details, including various tests, diet advice, and medicines prescribed to patient and GP. It also provides clinic details and billing facility based on patient’s status, whether it is an indoor or outdoor patient. The system provides the facility of backup as per the requirement. Mainly reduce the paper works of the hospital day to day activities.

I have used SmartDraw 2010 and GanttSoft Project Manager 2.0 softwares to draw the SDLC models, DFD, ERD and Gantt Chart for this assignment. I have attached a CD which contains the soft copy of completed assignment and all the images, which is used for this assignment. This assignment has led me to learn a lot of subjects about system analysis.