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