4 ms·
In the case of businesses especially, it is often the case that many people have the same (work) address. And, if that business moves, you want all of those pe
by rossdavidh 8y ago
In the case of businesses especially, it is often the case that many people have the same (work) address. And, if that business moves, you want all of those people to have the new address, without having to find them all and change all of them. Their work address is the Acme Business Address, id=573, which should be changeable once, rather than finding every record of every person there and changing it. But, the same person could easily have more than one address as well. Many-to-many matches that actual underlying reality, which is what is most likely to work well in the long run.
- HelloNurse 8y agoExample gratuitous complications: I don't want my address updated if my neighbour shares my address and he moves; if my partner breaks up with me on really bad terms and I move I don't want to share my new address. Probably, what's wrong is the concept of people having a relation with addresses while the actual relation is between a shipping and its target address. An example of doing it right: Backerkit (a site for crowdfunding-related surveys and orders) asks for an address every time there's something to send, and only later suggests using a similar previously entered address instead. No "updating", only separate transactions with their respective shipping addresses, all explicitly decided by the customer with some assistance in data entry.
- rossdavidh 8y agoHmmm...I see what you're saying, but if my business moves, and every person who deals with that company has to update their work address, and in the meantime it kept suggesting the old obsolete address that five other people who work there had already corrected, I would not be impressed.