0 Replies Latest reply on Sep 20, 2005 12:55 AM by Andrew Iggleden

    One table or many tables ?

    Andrew Iggleden Newbie

      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