Track 9 ¾ or the magic of data modelling

Many projects start with data modelling. Many projects suffer from a poor data model. In the workshop we will illustrate different principles of modelling based on an interesting example.How can train compositions like the Hogwarts Express be managed in a relational database? We assume that the magic train has one or more locomotives and different wagons for passengers and cargo. The task contains a few requirements that turn out to be not so easy when modelling. For example, it is not trivial to find the right spell, in other words, the right modelling. Respectively, there are different ways to map the requirement to a data model.The presentation will explain the initial situation and go into the different solution variants. As each variant has advantages and disadvantages.At the end of the lecture, you will take home different modelling patterns and know when which one fits and what the strengths of these patterns are. Just as a wizard or witch knows the effect of magic spells.