Saujib (7/2/2013)

---

hi

Here a requirement that I am trying to implement

One table Address is used by many tables. like member, provider and sales representative.

While creating Sales Order, User would entry information for member, provider and sales representative.

and address for each entity

member, provider, sales representative tables has reference to sales order table

Which is best way to create tables

1. member, provider and sales representative have FK to Address table

2. Address table has 3 columns for member, provider and sales representative.

3. Instead of address table, add columns to each table

member, provider and sales representative to address is one-one.