🛒 E-Commerce Platform with Database Management System

A full-stack e-commerce platform developed as part of the Database Management System course at the Department of Computer Science and Engineering, University of Dhaka.

---

🌟 Features

• User Authentication: Secure login and registration system
• Product Management:
  • Browse products with advanced filtering
  • Sort by price and ratings
  • Search functionality
  • Category-based filtering
• Admin Dashboard:
  • Sales analytics
  • Product management
  • User management
  • Database query demonstrations
• Responsive Design: Works seamlessly on desktop and mobile devices

---

🛠️ Tech Stack

Frontend

• Next.js 14 (React)
• TypeScript
• Tailwind CSS
• Tremor (for charts and analytics)
• Lucide Icons

Backend

• Node.js
• Express.js
• PostgreSQL Database

---

💽 Database Features

Demonstrates various SQL concepts including:

• Natural Joins
• Cross Products
• Outer Joins
• Nested Queries
• Aggregate Functions
• Group By and Having Clauses
• String Operations

---

🌐 Site Features

• Homepage:
  • Hero section with promotional content
  • Featured products display
  • Category-based product browsing
• Product Page:
  • Detailed product descriptions
  • High-quality images with zoom functionality
  • Customer reviews and ratings
• Cart and Checkout:
  • Add to cart functionality
  • Secure checkout process
  • Order summary and confirmation
• Contact Page:
  • Contact form for customer inquiries
  • Team member information
  • Project details
• About Page:
  • Information about the project and team
  • Mission statement
  • Reasons to choose us

---

🚀 Getting Started

1. Clone the repository

   git clone [repository-url]
   cd my-app

2. Install dependencies

   npm install

3. Set up environment variables Create a .env.local file with:

   DATABASE_URL=your_database_connection_string

4. Run the development server

   npm run dev

5. Open http://localhost:3000

---

👥 Team Members

• Md. Tauseef - Ur - Rahman
• Faiaz Mahmud Ifti

---

📞 Contact

For any queries:

• Email: [email protected]
• Email: [email protected]

---

🙏 Acknowledgments

This project is submitted as part of the coursework for Database Management System Lab at University of Dhaka.

🌟 If you find this project interesting or helpful, please consider giving it a star on GitHub! Your support motivates us to keep improving. 😊

---

📄 License

This project is part of academic coursework and is subject to university guidelines.

---

🛒 Project Video: https://www.youtube.com/watch?v=stafexxyMCA

---