Case study, Database Systems
A relational database design for a freelance marketplace, with normalized entities and SQL-side business logic.
Context
A marketplace has connected workflows for accounts, skills, projects, bids, and payments. The schema needs to represent these relationships while limiting duplication and preserving integrity.
My role: Academic database project; source files document schema and SQL features.
Implementation
Separate entity responsibilities and represent relationships explicitly, including skills and project participation.
Use keys and constraints to keep records consistent, and SQL-side features to package recurring operations.
Evidence
The points below summarize the public repository and owner-provided CV where noted. Read the source for implementation details and the evaluation setup before drawing further conclusions.
MySQL project repository.
Boundaries