You don't understand mathematics,
you just get used to it - jvn
I used to want to understand math (intuition); now I think of it as learning a language: lots of vocab and rules with some pattern. You need to become fluent - practiced, like a cellist or cricketer.
I think the primary problem of giving examples here is similar to teaching software engineering, which needs complex projects solving complex problems - too big for a semester project.
A good schema depends on the problem it's solving.
A secondary problem is similar to code that has sacrificed clarity for performance. The tweaks made for performance are not intrinsic to the logical problem, but are an additional constraint.
For performance on common queries, schema can be flattened or "denomalized". The ability to do so was one of the original motivations for Codd's relational algebra.