‘ 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 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.
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,
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 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 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
: 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
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
Primary Key – PatientID
Surgery Appointment :
Primary Key – AppointmentID | Foreign Key – PatientID & GPID
Primary Key – GPID
Primary Key – NurseID
Primary Key – TreatmentID | Foreign Key – AppointmentID & ClinicID
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
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.
Our academic experts are ready and waiting to assist with any writing project you may have. From simple essay plans, through to full dissertations, you can guarantee we have a service perfectly matched to your needs.View our services
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.
Cite This Work
To export a reference to this article please select a referencing stye below:
Related ServicesView all
DMCA / Removal Request
If you are the original writer of this essay and no longer wish to have your work published on UKEssays.com then please: