(Solved): a) Explain the process of normalization and its significance in ensuring data integrity. (5 marks) ...

a) Explain the process of normalization and its significance in ensuring data integrity. (5 marks) b) Apply normalization techniques to eliminate data redundancy in the hospital's patient management system. (10 marks) Physical Database Design: a) Select a suitable database management system (DBMS) for the hospital's patient management system. Justify your choice. (5 marks) b) Design the necessary tables and relationships (write SQL CODE) based on the finalized logical database design. (10 marks) Implementation and Testing: a) Describe the steps involved in implementing the physical database design. (5 marks) b) Explain the importance of testing in ensuring the accuracy, integrity, and functionality of the database. (5 marks) Deployment and Integration: a) Outline the process of integrating the newly designed database with existing systems, such as electronic health record (EHR) systems and appointment scheduling software. (10 marks) b) Discuss the techniques used for data migration from the old system to the new database. (5 marks) Maintenance and Optimization: a) Explain the post-deployment tasks involved in maintaining the database. (5 marks) b) Describe the strategies used to optimize the database's performance and ensure scalability. (5 marks) Conclusion: In a well-structured paragraph, summarize the key findings and benefits of applying the database design life cycle in the hospital's patient management system. (5 marks) Format and Submission Guidelines: Provide your answers to the assigned tasks in a separate document.