Let's continue exploring the design space of storing either/or data. In this part we discuss three arrangements: main table, side-table and per-attribute tables.
Unless you are already familiar with Anchor modeling it has many similarities with what you are discussing here. Particularly separating each attribute into its own table.
Unless you are already familiar with Anchor modeling it has many similarities with what you are discussing here. Particularly separating each attribute into its own table.
https://www.anchormodeling.com/
Lars,
discovering Anchor Modeling few years ago was hugely important for my understanding of database modeling.
Thank you for all you did,