Assignments
Throughout the semester you will complete three assignments that together account for 20 points. Assignment 1 focuses on data modeling, Assignment 2 on SQL, and Assignment 3 ties everything together in a working project. Start early, ask questions during seminars, and iterate on feedback — that is how good databases are built.
Database design and modeling. Conceptual, logical, and physical model of your project.
SQL queries — JOINs, aggregations, subqueries, and window functions.
Project implementation — seed data and basic queries on your database.
Assignment dataset
Assignment Template
All assignments must be submitted using the official LaTeX template:
- Assignment Template — GitHub Repository
- Download ZIP — grab the template and start working right away
The template contains the required document structure, formatting, and examples to get you started. Every student is required to use this template — submissions in other formats will not be accepted.
The template repository includes a CI/CD pipeline (GitHub Actions). If you work in your own GitHub fork or copy, the pipeline will build the PDF for you automatically on every push. This means you do not need to install LaTeX locally at all — just write, push, and download the built PDF from the Actions tab.