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.