I am currently building a databse scheme for a small company. But at the point doing it I figured out that my attept will be unacceptable due to the ability that one action will affect multiple unwated records.
To explain this. Currently I have one table addresses that links towards person, company, order etc.
The issue comes when we have a person that is linked to address ID 1, and a company address is linked to ID 1. And now when we want to change the company address - just one field like the building number from 5 to 6. The change will affect both the company and the person address - most likely all other attached to ID 1.
How should it be solved proffesionally - as the pro's build such scheme. My attept would be multiple address tables person_address, company_address etc. All would have the same fields which is not a optimal attempt I assume.
Thanks for any hints.