I believe you have seen a lot of confusing table and column names and wondered who made them. Here I'm considering the reasons why this happens.
Data Model Articles
See how easily and conveniently you can discover, browse and document table and column relationships in your databases.
Databases should but many don't have foreign key constraints. Does your database have them? To what extent? Here is a method to measure your database.
A compilation of reasons why databases don't have defined foreign keys.
6 most common metadata fields you can find in tables of many packaged and custom applications.
ER Diagram or Data Dictionary. What they are and which is better for documenting data models.
What is metadata in databases and why it's important to be able to find, access and use data.
Tutorial on creating Data Dictionaries with Dataedo.
Data Model, Data Dictionary, Database Schema, Entity Relationship Diagram. What are all those data related terms? What is the difference?
What is the difference between logical and physical Data Dictionary.