Freelancer Project Tracker

A MySQL database system for freelancers to manage clients, projects, and payments efficiently.

🛠 Tech Stack

📌 Scenario

This project models a real-world scenario where freelancers need to track:

• Client details
• Project assignments, deadlines, and budgets
• Payment records and methods

View scenario_description.txt for detailed scenario info!

🗃️ Schema Overview

• Clients: Stores client contact and company info
• Projects: Linked to clients, with optional descriptions, deadlines, and budget info
• Payments: Tracks amount, date, and payment method per project

🚀 Getting Started

• Import freelancer_db.sql into your MySQL environment to create and populate the database.
• Run the sample queries to interact with the data.

🧪 Sample Queries

🔹 List all upcoming projects

SELECT title, deadline FROM Projects WHERE deadline > CURDATE();

🔹 Projects per client

SELECT c.name, COUNT(p.project_id) FROM Clients c LEFT JOIN Projects p ON c.client_id = p.client_id GROUP BY c.client_id;

🔹 Total payments by method

SELECT method, SUM(amount) FROM Payments GROUP BY method;

---

MIT Licensed • © 2025 Herald Inyang •

---