A relational database project with ER modelling, DDL/DML, substantial query work and a Python API layer.
The problem
Reliable application data starts with a coherent relational model and with queries that reflect the intended meaning of the domain.
What was built
A relational database project with schema and ER files, DDL/DML, query implementations and a Python query/API layer.
Technical approach
- Model entities and relationships
- Define the schema in DDL
- Populate and change records with DML
- Write analytical and operational SQL queries
- Expose the queries through Python modules
Engineering decisions
- Treat the schema files as part of the implementation evidence.
- Keep this project as proof of database fundamentals, not as a flagship.
- Avoid unsupported claims about scale or production use.
How it was checked
- The repository includes ER and schema files, DDL.sql, DML.sql and query answers.
- Python api.py is present, along with request, query and utility modules.
What it shows
Foundations of relational modelling, SQL implementation and connecting persistent data to an application layer.
About the source
Academic engineering project. It deliberately ranks below the larger distributed and application systems.