Case Study: Optimizing Patient Data Management for a Health Clinic A health clinic has been struggling to manage its patient data effectively. Currently, patient information, including personal details, medical history, treatment plans, and appointment schedules, is stored in multiple spreadsheets. This leads to data redundancy, inconsistency, and challenges in retrieving accurate information quickly. The clinic plans to implement a relational database to improve data organization and accessibility. The goal is to design a system where each patient's details are easily accessible and can be updated without affecting other records. Additionally, they want to ensure that patient data is securely stored and accessible only to authorized personnel. Questions: 1. Design the Database Schema: Propose a basic database schema for the clinic. What tables would you create, and what would be the primary keys and foreign keys? Identify any relationships between tables. 2. Data Integrity: What data integrity constraints would you enforce to maintain accurate and consistent data? Explain the importance of each constraint in the context of the clinic's database. 3. Security Measures: Suggest some security measures the clinic should implement to protect patient data in the relational database. Why are these measures important in a healthcare setting