Health and Cure Hospital (H&C) is a new hospital in Amman and tries to provide the best medical care and facilities to its patients. After a short period of time, they noted that it is very difficult to keep records of its day-to-day activities manually as well as the medical staff information is not well-organized. The executive management in H&C believes that the business requirements have emerged and they need to invest in developing new technology. Therefore, they met the IT managers and they indicated that they need to develop a database system to organize all information about patients and medical staff in each department, in addition to that it will help to keep records of all hospital activities. H&C consists of a set of medical departments, such as the Surgical Department, Internal Medicine Department, and Pediatrics & Neonatology Department. Each patient has his own record that contains his personal information such as name, address, age, and so on. The hospital needs to track the information of its patients in every department. Each department has its own nurses and it contains its own rooms. Each room has a dedicated nurse who is in charge of it and has properties like room ID and number of beds. Also, each department has its own doctors. Each doctor fills out the patients medical report during the consultant and curing. The medical report contains the patient's medical information such as the prescription, medications, laboratory tests, date of entry into the department, and date of discharge from the department. The executive management has given approval to the IT department to hire a person to help build the new database. You are employed as a database developer and your manager asked you to implement a database application to support the basic functions of the hospital. The main duties assigned to you are to: 1. Investigate the requirements of the system. 2. Design, provide and implement the system. 3. Write technical documentation for a fully functional system.

Task 3 In this stage, the database solution should be functional and the proposed design of the relational database is already implemented. The next step before deploying the system is to test it. Your manager requires a brief report of the process of the testing that includes: A. Evaluation of the system against user and system requirements and provides relevant test cases for the database you have implemented. B. Analyse how the selected test data in (Task 3-part A) can be used to improve the effectiveness of testing. Finally, the prepared document should evaluate any future improvements that may be required to scale the system.