The technical solution isn’t the skill issue I’m pointing towards.

It’s the business modeling skill that most developers lack, so they skip it and believe an ERD will magically cover all invariants.