A person is a person unless they are a company

I once read that when making a database, rather than splitting up say employees from family into two different table, all are considered people and therefore all people should be put in one table where you then reference back to the table to associate the relations of husband and wife or children.

I am now looking at a database that I want to include companies with the address and phone numbers. I am wondering if it does not make sense than to just say all people and companies are Entities therefore should I just be putting in one table for all Entities. Sort of like the government in the sense that we all pay taxes regardless of whether we are a person or a company.

Part of the reason for asking is, I am trying to create a table with addresses but seems silly to create two tables, one for people and one for companies. So, I am thinking that I should have one table for address but how to deal with two separate table…one for people and one for companies.

Thoughts?

View full post on Tycoon Talk

, , ,

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Get Adobe Flash playerPlugin by wpburn.com wordpress themes


RSS Site FeedRSS Site Feed

© 1992-2011 DC2NET™, Inc. All Rights Reserved