Hello Guys,

I have encountered this multiple times and am never sure how to best model. I have organizations, each organization can have multiple locations. Each location will have multiple employees and I need to store addresses, not just for the business locations, but also the home address for each employee. I am never sure how to best model. It seems addresses should all be together but it also seems wrong to have some address records map to the Locations tal and some to the Employees. Do I put Locations and employees all in the same table (Parties)?

And this time, for each address in the database, there will be tracked their 3 political districts. Is there a standard or best practice or general advice?


Thanks

I didn't find the right solution from the internet.
References:
- http://www.accessforums.net/showthread.php?t=67069
- Referral Marketing Video Examples.

http://www.sql.ru/forum/1267699/modeling-orgs-suborgs-their-employees-and-addresses-for-all