This project aims to build a robust and scalable Database Management System (DBMS) for an online retail store similar to BlinkIt. It supports core e-commerce functionalities like product inventory, customer management, order processing, vendor management, and secure user authentication.
- Efficient management of products, customers, orders, and vendors
- Secure and scalable backend architecture
- Enhanced shopping experience for users
- Reduce holding costs with optimized inventory
- 👤 User account creation with address & payment method management
- 🛍️ Product catalog with categories, subcategories, and variations
- 🧮 Real-time inventory tracking and shopping cart
- 📦 Order placement with status tracking (processing → delivered)
- ✍️ Ratings and reviews (1 to 5 stars + text feedback)
- 📜 Order history and reordering options
- 🎯 Personalized product recommendations
- 💸 Discounts, promotions, and secure payment processing
- 🧑💼 Vendor portal for managing products, prices, and orders