to add additional tables or not?

[phineas629]

I have a table for "people" which is basically individuals and their contact info. I have another table for "people type" i.e. client, emergency contact, doctor, etc. However, only clients has an "insurance provider" and there are more than one insurance company. Would it be best to add another table for "insurance provider"and use client foreign key or should I keep all information on the "people type" table? Should I make a seperat table for clients?

Thanks

[alansidman]

this should help you in db design.

http://www.deeptraining.com/litwin/d...aseDesign.aspx