What I loved about the JD Edwards database I had peripherally deal with was the lack of enforced foreign keys. Thus, you got to guess at where the proper joins were.

But ... from a developer standpoint it often doesn't matter what the table name is. Especially if one uses an ORM, where they can easily name them in code in a meaningful manner. In fact, I did just that kind of thing for dealing with the JD Edwards database. I gave my tables friendly names, and setup relationships.