🚀 Servix – Service Marketplace API

A service marketplace platform that connects customers with verified service providers. Built using PostgreSQL, the project follows a layered architecture and a normalized relational database design to provide scalable, secure, and efficient services.

---

✨ Features

• 👤 Customer registration
• 🛠️ Service provider management
• 📅 Service booking and scheduling
• ⭐ Ratings and reviews
• 📂 Service category management
• 🔍 Search and filtering
• 👨‍💼 Admin operations
• 🗄️ PostgreSQL database with 23 BCNF-normalized relational tables

---

🏆 Key Achievements

• Designed a 23-table BCNF-normalized PostgreSQL database to ensure high data integrity and minimal redundancy.
• Implemented optimized SQL queries, centralized exception handling, and request validation.

---

📂 Project Structure

sql/
 ├── servix_ddl.sql
 ├── servix_data.sql
 └── servix_queries.sql

docs/
 ├── ERD
 ├── Schema
 └── Normalization Proof

---

🚀 Getting Started

Installation

git clone https://github.com/KrIsH-1206/SERVIX-API.git

cd SERVIX-API

---

🗄️ Database

The project uses a BCNF-normalized PostgreSQL database consisting of multiple relational tables designed to minimize redundancy while maintaining efficient querying.

Database scripts included:

• Database Schema (DDL)
• Sample Data
• SQL Queries
• ER Diagram
• Normalization Proof

---

📌 Highlights

• Clean layered design
• PostgreSQL relational database
• SQL query optimization

---

👨‍💻 Author

Krish Vamja