I have an example of how a puppini bridge can be built on my blog if you're interested:

I also dive a bit deeper into how the USS solves the Fan/Chasm trap -> https://showmethedata.blog/sql-traps-unified-star-schema