And this doesn't even get into "which normalization approach!" or "what gets signed (or not)!"

It's an absolute dumpster fire.