Analyze the requirements of a Kenyatta National hospital management system and design a relational database to manage patients, doctors, staff, appointments, and medical records.

Key Points to Cover:

Requirements analysis and system architecture

Entity$-$relationship $($ER$)$ diagram

Database schema design

Implementation details $($SQL scripts, stored procedures$)$

Data security and privacy considerations

Example queries and reports

Challenges and solutions

Develop a database for an Mount Kenya Noir Coffee Limited e$-$commerce platform that handles roasted coffee, customers, orders, and payments.

Key Points to Cover:

Requirements gathering and functional specifications

ER diagram and normalization process

Database schema design

Performance optimization techniques $($indexes$,$ partitioning$)$

Security measures $($encryption$,$ access control$)$

Integration with web applications

Example queries and performance analysis

Design and implement a secure database system for Equity Bank online application, including accounts, transactions, loans, and customer information.

Key Points to Cover:

Requirements and security considerations

ER diagram and schema design

Implementation details $($SQL$,$ transaction management$)$

Data encryption and access control

Fraud detection and prevention mechanisms

Example queries and reports

Challenges and mitigation strategies