Skip to content

Latest commit

 

History

History
59 lines (38 loc) · 3.38 KB

README.md

File metadata and controls

59 lines (38 loc) · 3.38 KB

Online Auction System

This project focuses on the design and implementation of a comprehensive database schema for managing users, items, bids, auctions, and transactions in an online auction environment. 🎉

Project Overview

The Online Auction System is designed to facilitate seamless interactions between buyers, sellers, and admins through a well-structured database schema. Key features include:

  • User Management: Centralized user profile management with details such as unique User_ID, Username, Password, Email, Address, preferred payment methods, and transaction history.
  • Item Management: Detailed tracking of auction items with attributes like Item_ID, Seller_ID, Item_Name, Description, Starting_Price, Auction_End_Time, item condition, category, and images.
  • Bid Tracking: Real-time bid tracking with unique Bid_ID, Bidder_ID, Item_ID, Bid_Amount, Bid_Time, bid status, and bid increment.
  • Auction Management: Comprehensive auction tracking with Auction_ID, Item_ID, Auction_Start_Time, Auction_End_Time, auction status, and reserve price.
  • Transaction Recording: Management of completed transactions with Transaction_ID, Buyer_ID, Seller_ID, Item_ID, Transaction_Amount, Transaction_Time, payment method, and transaction status.

Tech Stack

This project leverages a variety of technologies to deliver a robust online auction system:

  • Frontend:

    • React.js: For building the user interface and enhancing user experience.
    • Tailwind-CSS: For styling and responsive design.

  • Backend:

    • Node.js: Server-side JavaScript runtime environment for building scalable network applications.
    • Express.js: Web application framework for Node.js to handle HTTP requests and routing.

  • Database:

    • PostgreSQL: Relational SQL database management system for storing and managing data related to users, items, bids, auctions, and transactions.

  • Data Visualization:

    • Power BI: For visualizing and analyzing data in real-time with interactive reports and dashboards.

  • Development Tools:

    • Git: Version control system for tracking changes in source code.

Features

  • User Profiles: Manage and view user profiles with complete transaction history.
  • Item Listings: View and list items for auction with detailed information.
  • Real-Time Bidding: Track and place bids in real-time.
  • Auction Management: Start and manage auctions with reserve prices and status updates.
  • Transaction Processing: Record and manage transactions post-auction.

Documentation & Setup

Demo & Documentation

Check out the following resources to better understand the project:

  • Demo Video: A video demonstration of the Online Auction System in action.
DBMS_Project_Video.mp4