SmartGrocery: E-Commerce SQL Database

A SQL database project for managing an online grocery store. It includes customer management, shopkeeper inventory, order placement, and analytics.

🔧 Technologies

• MySQL
• phpMyAdmin or MySQL Workbench
• XAMPP or any MySQL-compatible local server

📁 Files

• schema.sql – contains all table definitions
• sample_data.sql – includes sample inserts for testing
• queries.sql – demo queries for testing the system

🧪 How to Use

1. Import schema.sql into your MySQL database.
2. Run sample_data.sql to populate tables.
3. Use queries.sql to explore the system.

📌 Use Case

Ideal for academic projects and as a backend blueprint for a hyper-local e-commerce platform like PadosiMart.

SmartGrocery_SQL_Backend

A complete MySQL backend for SmartGrocery—built for hyperlocal e-commerce platforms like PadosiMart. Includes a scalable schema, rich sample data, and queries for order tracking, inventory, and customer analytics.