faysel-abdella / sql-group-4 Goto Github PK

## Online Auction Platform

Our project is creating an Online Auction(ጫረታ) Platform. In this docs I'll try to go trough each details one by one
to make things very clear.

- In this first intro we will see..
  1.  overview (how it works)
  2.  what does the main functionalities required?
  3.  what concepts to be included?
  4.  steps before development?
  5.  steps through the development?
  6.  what is the final result?

1. Overview
   an Online Auction Platform is a system that facilitates the buying and selling of goods. It allows users to place bids on items and compete with other participants to win the auction

   # How it works ?

   ✅ User Registration and Authentication:
   • Users can create an account on the platform.
   • The database stores user records, including usernames, passwords
   ✅ Item Listing:
   • Sellers can create listings for the items they wish to sell, providing details such as item description, starting price, auction duration.
   • The database stores item records, including the seller's information, item details, and the current status of the listing.
   ✅ Bidding Process:
   • Users can place bids on items they are interested in.
   • The database stores bid records, including the bidder's information, the item being bid on, the bid amount
   ✅ Auction Management:
   • The platform manages the auction process, including incrementing bids, updating the current highest bidder, and tracking the remaining time for each auction.
   • The database keeps track of the bid history for each item, along with the current highest bid and the auction end time.
   ✅ Payment and Transaction Management:
   • Once an auction ends, the platform handles the payment and transaction process between the winning bidder and the seller.
   • The database may store transaction records, including payment details, shipping information, and confirmation of the completed transaction.

2. what does the main functionalities required?
   covered above

3. what concepts to be included?

   - procedure
   - transaction
   - view
   - trigger
   - security
   - project

4. steps before development?

   - identifying actors (entities)
   - Drawing the ERD
   - schedule a time frame

5. steps through the development?

   - using native SQL queries
   - using best practices
   - deploy each progress on github
   - contribute to this project
   - merging pulls

6. what is the final result?

- A full functional SQL DB query using