I created a business management by Rozina BegumI created a business management by Rozina Begum

I created a business management

Portfolio project
Rozina Begum
I created a business management project called Donut Shop. It has two main parts: a PostgreSQL database (where all the shop's data is stored) and a Streamlit dashboard (where that data is shown as easy-to-read reports and charts). Database: I built the database in PostgreSQL because it is fast, reliable and flexible, and it can grow as the shop grows. It is a relational database, which means the tables are connected to each other, so the data always stays organized and consistent. The database has 3 schemas, 25 tables, 32 procedures and 9 triggers. Schemas (the 3 main sections of the database): ● Inventory: tracks ingredients, donuts, suppliers and stock levels. ● HR: manages employee roles, shifts and salary payments. ● Sales: handles customer data, orders, payments and some ready-made reports. Tables: The 25 tables work together to manage the whole shop. They cover inventory, suppliers, stock levels, employees, orders, general logs, waste logs, and everything else you would expect a shop to keep track of. Procedures: A procedure is a ready-made set of steps stored inside the database. All adding, updating and changing of data goes through these 32 procedures. This makes every operation faster and safer. Each procedure checks the data first, handles errors properly, and gives a clear error message if something goes wrong. Because of this, nobody needs to change or insert data into each table by hand. Triggers: The database has 9 triggers. Think of a trigger like an automatic watchman who is always watching the database. The moment any data is added, updated or deleted, the watchman steps in right away, with no manual click needed. These triggers do very important jobs. For example: ● When a new order item is added, a trigger automatically updates the stock, so inventory is always accurate. ● When a donut's price changes, a trigger saves the change and updates the old price to the new one in the donuts table ● When an employee's salary changes, a trigger saves the change in the salary history table, so every raise or change is recorded. Dashboard The Streamlit dashboard connects to the database and shows the shop's data as KPIs, tables and charts. The owner can see sales, stock and staff information in one place, without touching the database. Tables can be filtered and downloaded as CSV files, and charts can be saved as images. Powered by Polars: For data analysis, the dashboard uses Polars instead of the more common pandas library. Polars is a modern, high-performance tool that is faster and handles data more efficiently, so reports and charts load quickly and the dashboard keeps performing well as the shop's data grows. This is one of the key features of this project.

0 likes · 0 views · Oct 20, 2026

I created a business management project called Donut Shop. It has two main parts: a PostgreSQL database (where all the shop's data is stored) and a Streamlit...

Tags