"But isn't it the way it's supposed to be?" you ask me. Well, kinda of. I do think to model the data for any given business you should study it a bit first. But the way I'm doing it isn't optimal at all.
If you're wondering what I mean by that I have a simple, often overlooked example: geographical addresses. If you're just addressing your own country, it's usually straightforward enough. But if you're addressing several countries oh oh. My go to reference is the Google Places API and their address components[1].
So my question is: is there a place where we gather data modelling guides for different industries? Like introduction to their workflow, so you understand how entities relate to one another and how to best split the data, and a glossary to name the fields appropriately? I know businesses work differently around the world but I also often find that the core idea and consequently its data stays largely the same.
Other industries I had to work with in the past are:
- Postal and courier services - Multi-level marketing model - Tourism - HR, recruiting and selection
For all of these I had to scramble with hundreds of Google searches to understand just enough so I could provide a decent data model. I just wish I had a guide for it.
Thanks and happy new year.
1. https://developers.google.com/places/web-service/supported_types#table2
Also might be worth reading https://programminghistorian.org/en/lessons/intro-to-linked-...