The Phoenix Hospital has asked me to create a computer application to replace the existing manual one. In this system patient details have to be kept and information about borrowing of equipment.

Authors Avatar

.Candidate Name: Leo Kadis        Candidate Number: 6677       Module 3 Hospital Equipment Loan System                

Write up for Hospital Equipment

Loan System

Specification

Background

The Phoenix Hospital has asked me to create a computer application to replace the existing manual one. In this system patient details have to be kept and information about borrowing of equipment. Records must be kept of what equipment has been borrowed, by whom and when, and also if any equipment is not available because it is being repaired.

Aim

My aim is to successfully create a database for the hospital, which they can4

use on an everyday basis. The database will need to:

  • Ability to store details of equipment.
  • Item code to identify the item and the type of equipment.
  • For each piece of equipment it must find:

- whether it is available, being repaired or out on loan

- if on loan, to whom and at what address or ward number

- if on loan, when is it due to be returned or the loan renewed

- if being repaired, when was it sent for repair

  • Produce a hard copy of the above information for any piece of
Join now!

equipment.

  • Equipment is lent out for a 6- week period, this can be renewed for

periods of 6 weeks.

  • Patients may have more than one piece of equipment on loan at a

particular time.

  • At any one time, about half the equipment will be out on loan and 1 or 2

pieces will be in for repair.

  • Names and addresses of patients are to be invented. Ward numbers are

W1- W10.

  • At the end of each week, a full report of the location of all equipment is

to be produced. If equipment is due for return or renewal during the

...

This is a preview of the whole essay