This project involves the design and implementation of a PostgreSQL database for efficient convenience store management. Entity-Relationship and relational models were developed to ensure a well-normalized and optimized structure. Additionally, triggers and functions were implemented to enhance data integrity and automate key processes, such as inventory updates and sales tracking. The system's optimization ensures high performance in queries and transactions, making this database a scalable and efficient solution.