🏥 Pharmacy Management System

A Streamlit + MySQL based full-stack Pharmacy Management application with Admin & User login, CRUD operations, stored procedures, and a clean user interface.

---

📌 Features

👩‍⚕️ Admin Panel

Admins can:

• Add / Update / Delete / View Medicines
• Manage Companies
• Manage Customers
• Manage Customer Phone Numbers
• View Reviews
• View Bookings
• View Payments
• View Supplied By
• View Books (Relationships)

👤 User Panel

Users can:

• View Medicines
• View Reviews
• View Bookings (including stored procedure output)

---

🗄️ Tech Stack

• Python
• Streamlit
• MySQL
• MySQL Connector
• Pandas

---

📂 Project Structure

📁 Pharmacy-Management/
│── Pharmacy Management.py
│── Pharmacy Management_PES2UG24CS813_PES2UG24CS806.sql
│── README.md

---

🛠️ Setup Instructions

1️⃣ Install Dependencies

pip install streamlit mysql-connector-python pandas

2️⃣ Set Up MySQL Database

Run this command inside MySQL CLI or Workbench:

SOURCE Pharmacy Management_PES2UG24CS813_PES2UG24CS806.sql;

This will:

• Create all tables
• Insert sample data
• Create constraints & foreign keys
• Create users for login

---

▶️ Run the Application

streamlit run "Pharmacy Management.py"

---

🔑 Login Credentials

Admin Login

Username: Manju  
Password: Manju123

Sample User Login

Username: user1  
Password: user123

---

🤝 Contributors

• PES2UG24CS813 – Manjunath K Byadagi
• PES2UG24CS806 – Arvind

---

⭐ Future Enhancements

• Add JWT-based authentication
• Add medicine stock system
• Add medicine expiry notifier
• Add charts & analytics
• Add invoice generation

---