Posted on 2013-01-16
I have a table called School. Then I have a table Called SchoolContacts. They are joined by a SchoolID.
Then, I have a table called Hosptial, as well as HosptialContacts. They are joined by HospitalID.
SchoolContacts & HospitalContacts have the same fields except SchoolID and HospitalID.
Is seperating these two contact tables the best table design, or is there a better design or other options to keep all contacts in one table, and possibly eliminating some redudancy.
I am using linq to sql as well as sql server.