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

SYSTEMS AND DATABASES - COURSEWORK - Essay Example termination A infobase solution would ensure fall in storage, addition, modification and deletion of resident records so that bed allocation is handled breach. Bed allocation would not single help the care manager but also the placement officer to know the affordable rank 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. hassle definition The soak up records are not well maintained for immediate allocation and is very tight to know the availability of the nurses for resident allocation and assignment. Even their weekly payment hours are some epochs faulty.Solution A database system with alerts (triggers) would be largely helpful in knowing the reorder level for nurses 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 connecte d with the pharmacist who would ensure better and by the way delivery of drugs for use by the home. Again the proposal for an interconnected system like that of ERP is about useful in such cases. It would not only manage the diverse elements but would also make out 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 patients 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 guide 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