GP Bakery Management System

A database-driven bakery management system developed using Python and MySQL to demonstrate role-based access and backend integration.

Project Overview

This project simulates a real-world bakery management system with separate Admin and Customer roles for managing bakery operations and placing orders.

Features

• Admin authentication and password management
• Category, item, and flavour management
• Customer order placement
• Order history and order viewing
• Menu-driven console interface

Technologies Used

• Python
• MySQL
• PrettyTable

Database Requirement

This project requires MySQL with a database named gp_bakery. Users must create the required tables and update their MySQL credentials in connection.py before running the project.

Learning Outcomes

• Python–MySQL database connectivity
• Writing and executing SQL queries
• Modular programming in Python
• Role-based system design

Author

Gayatri Padalia