Your Status: Logged out Log in

Hospital Equipment Loan System  

Member rating: No Rating | Words: | Submitted: Tue Sep 02 2003

Page Preview
Preview
Previous 1 of 6 Next

On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:

Hospital Equipment Loan System Introduction I have been employed to produce a computer application to check and keep record of loans to patients of equipment such as wheel chairs and crutches. Records must consist of the following data, what has been borrowed, to whom it is been loaned to, when it was given for loan and if any equipment is not available because it is damaged and waiting to be repaired. Data Requirements Data Definition Table: Data Description Data Type Patient Number Key Entity 99999 Patient Name Name of Patient A (20) Patient Address Location Of Patient X (30) Telephone Number Patient Contact 99999 999999 Patient Status Is patient in Hospital or at Home A (10) Patients Ward In which ward is the patient X (3) Item Number Key Entity 999 Item Description What the Item is A (20) Item Status Is the item available, on loan or in repairs A (20) Number of Items in Stock Amount of Item in Stock 9 Item for Repair How much of the Items are in Repair 9 Date sent for repair When item was sent for repair DD/MM/YYYY Item loan If the item is...

Get instant access



  • Instant, unlimited access to our documents in full
  • Swap your work for free access, or pay £4.99
  • To see the full version of this document and 147,231 others
Register Now
OR

Receive email updates for this category



  • Simply tell us your email address and receive a weekly Study Help Email for FREE
  • Receive 3 FREE essay views with each email
  • Get all the latest essays from Coursework.Info & discussion from TheStudentRoom.co.uk