This project is a database system for a second-hand marketplace, inspired by Yad2.
The idea was to create a structured SQL-based backend that can support buying, selling, and managing ads in a clear and organized way.
- Lets users publish products for sale.
- Provides search and filtering options (by category, price, status, keywords).
- Supports communication between buyers and sellers through messages.
- Includes advertisers with ad packages and promotions.
- Keeps an archive of old products after they are sold or removed.
- Database: MySQL
- Main entities: Users, Products, Categories, Advertisers, Packages, Messages, Wishlists, Areas.
- Logic: Implemented with stored procedures, triggers, and views to manage data and automate tasks.
- Permissions: Different roles (Admin, Advertiser, Registered User, Guest) with different levels of access.
The project shows how to design a real-world database system with integrity rules, user management, and business processes.
It’s not just about creating tables – it’s about making sure the system works smoothly, is secure, and can grow with more users.