Hospital Equipment Loan System

20.2 Background One of the administrative tasks in a hospital is to keep a record ofloans to patients of equipment such as wheel chairs and crutches.The patients borrowing the equipment may be still in hospital or they may have been discharged. Records have to 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.You have been asked to create a computer application to replace the present manual one to record the necessary details to enable greater control to be kept and so cut down on loss and wastage.20.3 Specification 1. Ability to store details of the equipment. For the purpose of this exercise, only the following items need be recorded, although in practice there would be many more.Description of ItemNumber inStockCost ofReplacementWheelchair – Junior 2 �275Wheelchair – Small 2 �295Wheelchair – Medium 3 �320Wheelchair – Large 2 �350Crutch – Junior 4 �75Crutch – Adult 6 �95Elbow Crutch – Junior 2 �85Elbow Crutch – Adult 4 �105Neck Collar – Junior 3 �17.50Neck Collar – Adult 5 �23.752. A suitable Item Code is to be devised which identifies each piece of equipment individually, while also indicating what type of equipment it is.3. The data which is recorded should be sufficient to find the following information for any individual piece of equipment: ??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 repairComputing – Advanced Subsidiary and A Level, 2001/20024. It may be necessary to produce a hard copy of this information for any piece of equipment.5. Equipment is lent out for a 6-week period in the first place, but this loan can be renewed for periods of 6 weeks.6. A patient may have more than one piece of equipment on loan at a particular time (e.g. 2 crutches and a wheelchair).7. At any one time, about half the equipment will be out on loan and 1 or 2 pieces will be in for repair.8. Names and addresses of patients are to be invented. Ward numbers are W1 – W10.9. 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 following week, that patient will be contacted. There is a standard letter for this purpose.20.4 Test Plan The test plan should cover all parts of the system, including checkingthat the number in stock cannot become negative, and that any one piece of equipment is not logged as being in two places at once.20.5 Requirements for thePractical ExerciseCandidates are expected to design and implement an appropriate computing system and provide sufficient documentation to demonstrate the following practical skill.??Design??Implement / TestCandidates are expected to produce brief documentation including some or all of the following, as appropriate.Design??definition of data requirements;??user interface design including output, forms and reports;??method of data entry, including validation;??record structure, file organisation and processing;??security and integrity of data;??system design.Implementation / testing??hard copy output to prove the correct working of the system;??hard copy of solution, e.g. annotated program listing, spreadsheetshowing formulae.This documentation is to be brought to the examination and handedin with the candidates’ answer script for Unit 3. A Cover Sheet,signed by the teacher and the candidate, authenticating the work ofthe candidate, must be attached to the documentation (see