Current state of business and data related problems: The hospital’s existing database system has their patient and staff’s data fragmented i.e., divided across several applications and databases. The database system has been growing organically and now suffers from several shortcomings. Many different form of data storage systems and formats are used such as local disks, network access storage systems, spreadsheets, relational databases etc. Many different forms of data exist such as tabular data in excel sheets, images and videos, digital documents, scanned paper documents, specialised medical images in DICOM format, transcriptions, nurse, GP, specialist’s and psychologist records and notes. The staff are currently spending lot of time to retrieve data from different databases and connect them to make the case history of a particular patient or staff. Moreover, there are constant changes regarding to the patient ‘s personal details, their locations, medical condition, physicians or psychologists that they get treated from. Staffs ‘records also need to be updated. For example, employment’s details such as their expertise, work experience, new positions needed to be updated. Based on the hospital strict security policies, they want to keep record of all present and past staff. Although these data would not be used much, hospital would like to store and secure them. With all these complexities, generating a patient’s or staff’s report is time consuming and suffers from several integrity issues. Multiple copies are created and stored which causes redundancy, affects quality, and increases risk of data loss and exposure. Thus, the hospital is looking for ways to manage their documents and contents efficiently. They aim to digitize and store all archived patient history, collect present data responsibly, so that healthcare providers can easily request, use, update, and delete it as necessary. Furthermore, by digitizing the staffs’ record they will be able to keep track of staff and their responsibilities. The data are currently stored in on-premises storage facilities such as network access storage and local disks with back-up servers all on a local network. The hospital considers this local storage of data as a secure option for storing personal health and other sensitive information, though it is affecting their data quality and impacts the outcomes during audits where they struggle to meet regulatory requirements. Hence, they are seeking advice on benefits and challenges of their current in-house storage approaches and potential alternatives to data management with increased security and data protection. To keep up with their growing patient populations and accommodate their needs, the hospital recently opened an in-house imaging facility, and their database is expected to rapidly grow with high volume of digital unstructured data such as MRIs, CT scans, X-ray, and PET scans. Hence in addition to security, they are also aiming to achieve scalability, interoperability, and ease of integration without a huge impact on their funding. To improve patient support, they are introducing a new model of medical treatment using a telehealth platform and are accommodating new sources of data through IoT for remote monitoring. This again is creating new types of data with integrity and security issues. Overall, the organization needs a highly scalable and reliable data management solution that identifies and address their existing issues and provide a futuristic solution to accommodate their digital transformations and growth. Identify issues in this case scenario from data management perspective and suggest solution for the issues with references