Having lived thru the evolution of database design, cutting my teeth on IMS and linked list, working on the core of IDMS, and developing "add ons" to these DBMSs to simulate a table based SQL environment I can tell you stories.
GEDCOM is nothing more than a linked list, with only 3 primary record types and a few additional minor record types. None of them are facts. This does not say that they could not have a fact record type (or place, citation or name) but because most programs did not want to think beyond this basic design they did not do much more. This is why PAF only supports one name and used hacks to give us more. And why FTM supports both the PAF aka name hack and the more robust multiple NAME tag system.
I started working as a Database design consultant in 1980 trying to move clients from reading flat files and building linked in-memory list to using more robust DBMSs. Those were fun times, some sites still use the same technology today.