Joshua Kaila D2: EVALUATE THE LOGICAL DATA DESIGN MODEL (P5 & P6) AGAINST THE ORIGINAL BUSINESS REQUIREMENTS OF FOCUS EYE CLINIC AND JUSTIFY ANY CHANGES FROM THE ORIGINAL SPECIFICATION, MAKING FURTHER RECOMMENDATIONS IN THE LIGHT OF THE PRESENTATION IN M3 AND ANY POTENTIAL FEEDBACK THEY MAY HAVE RECEIVED AS A RESULT. 1. Below explains the issues with the current system used by the Focus Eye Clinic. The current system at Focus Eye Clinic is ineffective, resulting in poor management and irregular data updates. As a result, the system falls short of meeting the clinic's operational requirements and goals. Inefficiencies within the system lead to data blending and the creation of inaccurate information. With the clinic's expansion and the increasing number of patient registrations, the current system struggles to cope with the growing data volume. This presents challenges for staff in accessing and handling detailed patient information, including extensive medical histories that require manual entry and verification for accuracy. The slow performance of the system at Focus Eye Clinic stems from the chaotic handling of a large amount of processed data. Moreover, the system's age contributes to issues like freezing and unresponsiveness. Staff members encounter difficulties in promptly accessing well-organized information. Additionally, the lack of inter-branch connectivity impedes seamless data sharing and access for staff across separate locations. This fragmented system setup complicates staff members' ability to retrieve patient details from various branches. Security risks arise due to insufficient security measures, heightening the system's susceptibility to potential hacking threats. This raises concerns about unauthorized access and misuse of patients' sensitive data. Inadequate data synchronisation across multiple spreadsheets results in disjointed updates and difficulties in efficiently accessing interconnected data. The absence of proper data organization raises doubts about data accuracy and reliability, impacting the credibility of the stored information within the system. 2. Does the system meet the requirements of the business? To ensure that the logical model aligns with the business requirements, the manager must effectively implement the system to evaluate its feasibility, manageability, and alignment with the intended objectives. Providing sufficient time for the set-up of the new system and training sessions for staff enhances the likelihood of successful implementation. Consistent execution of security measures and validation procedures ensures the system's ease of management. Adequate training for staff members facilitates their comprehension of the system and enables them to efficiently handle all patient data. However, this process may result in increased costs, as the expertise of a data specialist may be
Joshua Kaila necessary due to their in-depth knowledge of the new system. Support from specialists may also be essential to maintain the system, given its diverse array of features. By integrating the system with the GP system, which contains automatically updated patient medical information, the system's capabilities can be expanded. This integration benefits opticians by granting them access to patients' medical records. For instance, if a patient has diabetes, this information can be readily viewed by the optician through the system. The database will meet the business requirements by