I am putting together a DB for the first time and need some guidance
as to what would be the best way to setup my tables. My database will
include employees (some who work at home), stores (where employees
work, and where things are mailed), regional offices (where employees
work, and where things are mailed). So thinking about it I was going
to setup a table for people, stores, offices, and addresses and link
addresses to people, stores, and offices. Basically I need the ability
to send things to a person at multiple addresses, some of which are
shared by multiple people.
Does this make sense?
|
