Data architecture Design

For the data architecture we used a star schema with facts and dimensions based on flat files. The star schema is a type of relational database that is composed of a single, central fact table surrounded by dimension tables. Furthermore, we used a bridge table with unique valid combinations of the WWTP, municipality and date to allow for cross-filtering of these variables.