DBMS-miniproject

DBMS E-Commerce Application which consists of advanced database concepts.

🎯 Project Overview

This project demonstrates a complete E-Commerce platform with:

• Role-Based Access Control (RBAC) - Admin, Seller, and Customer roles
• Secure Authentication - Password hashing and session management
• Advanced SQL Features - Triggers, Stored Procedures, Functions, Cursors, Views, Transactions
• Full CRUD Operations - Product management, order processing, inventory control
• Interactive UI - Modern, responsive web interface with Bootstrap 5

✨ Features

Customer Features

• User registration and login
• Browse and search products
• View product details and reviews
• Add products to cart
• Checkout and payment processing
• Order history and tracking
• Product reviews and ratings

Admin Features

• Dashboard with statistics
• Product management
• Order management and status updates
• User management
• Audit log viewing
• Sales reports and analytics

Seller Features

• Product management
• Sales reports
• Order viewing

🛠 Technology Stack

Backend

• Python 3.8+
• Django 4.2 - Web framework
• PostgreSQL/MySQL - Relational database
• Django ORM + Raw SQL - Database operations

Frontend

• HTML5, CSS3, JavaScript
• Bootstrap 5 - UI framework
• Bootstrap Icons - Icon library

Database Tools

• MySQL Workbench (for MySQL)
• pgAdmin (for PostgreSQL)