🐾 Pet Shop Food Inventory Management System (DBMS)
A complete system for managing food products, stock levels, expirations, suppliers, and sales tracking.
⭐ PROJECT OVERVIEW
A pet shop manages a wide variety of food products—dog food, cat food, fish flakes, bird seeds, reptile pellets, etc. Some are dry goods, some are wet goods, some expire fast, some arrive in bulk.
This DBMS centralizes:
Product catalogs
Categories (species type, food type)
Batch tracking
Stock monitoring
Expiration management
Supplier management
Purchase & sales workflow
Alerts for low stock & near-expiry items
Perfect for PHP + MariaDB because it involves:
CRUD operations
Inventory logic
Reports & dashboards
Authentication
Notifications
🧩 KEY FEATURES (Expanded)
1️⃣ Product Catalog Management
Store all pet food items in a structured database:
💡 Each product has:
Product name (e.g., “Royal Canin Puppy”, “Tetra Fish Flakes”)
Category (Dog, Cat, Bird, Fish, Reptile)
Type (Dry Food, Wet Food, Treats, Milk Rep…
