This repository consists in four projects submitted for Data Bases (2020/2021), a curricular subject of CS Degree at IST.
These four projects consist in different stages of the development of the Odisseia Data Base.
P1 - Database structuring, ER diagram
P2 - Relacional model, queries in relational algebra and SQL
P3 - DB implementation, schema, population, queries in SQL and web API using Flask
P4 - Trigger implementation, Indexes implementation, Star Schema approach, etl and olap queries