SYSTEMS AND DATABASES - COURSEWORK Essay Example | Topics and Well Written Essays - 1000 words

SYSTEMS AND DATABASES - COURSEWORK - Essay Example Solution: A database solution would ensure better storage, addition, modification and deletion of resident records so that bed allocation is handled better. Bed allocation would not only help the care manager but also the placement officer to know the affordable rates for the beds for fund approval process. Databases namely Oracle or MySql server can be used for storing and retrieving the records of beds and residents. Problem definition: The nurse records are not well maintained for immediate allocation and is very difficult to know the availability of the nurses for resident allocation and assignment. Even their weekly payment hours are sometimes faulty. Solution: A database system with alerts (triggers) would be largely helpful in knowing the reorder level for nurse’s availability and their filling up with buffers so that patients are taken care and attended at all times. Solution: An information system should be well connected with the pharmacist who would ensure better and timely delivery of drugs for use by the home. Again the proposal for an interconnected system like that of ERP is most useful in such cases. It would not only manage the various elements but would also reduce their operation cycle time in terms of effort and time taken by the various actors like the care manager, nursing manager and others to accomplish a task. As the hospital demands quick and timely action to keep up with the patient’s medical demands, an ERP system would ensure effective data transfer and reduce their lead times (Ballou, 2002). Solution: The updation of records are essentially required for fetching the exact state of the patients at all times. The system must reflect that at every point of time as to the status of the patient. A database solution would ensure better management of the home and ensure a reflection of the