Data should be organized around the building address, not owner name
Which is more likely to change, a building address or a building owner?????
In some industries, it makes sense for the data to be built around a person. Not in our industry. The data should all be built around the address. You can still "relate" several buildings to a single owner.
JOBS can be completely eliminated if you use the building address as the "PRIMARY KEY" field. This is the one field that won't change.
1
vote
Beth Anderson
shared this idea