Hospital Equipment Loan System
Member rating: No Rating | Words: | Submitted: Tue Sep 02 2003
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...


