I was wondering if someone could comment on the following.
I have an employer entity that has a 1 to many relationship with employees. The employer has it's own address and obviously each employee has their own address.
Would it be better to have a table that contains all addresses including the employers address or have one table for employer details and one table for employees ?
Or maybe there is another option that i'm not seeing.
tia
Andrew