I used to work at a healthcare technology company that was headed on the tech side by a database nut. The data model was both sprawling and very normalized (by that, I mean gnarly). We worked mainly in the exciting realm of medical billing and patient demographic data – particularly involving data with errors and omissions needing correction. Concordantly (😏), a large proportion of the relationships between tables were represented with nullable foreign keys.
I often found myself working on code similar to this contrived simplification …