It happened that I got the offer to write an article series in the German Java Magazin. So, here is the link to the first part:

https://entwickler.de/datenbanken/design-und-erste-praktische-schritte