General schema questions

From: <grantallenbrown_at_gmail.com>
Date: 10 Apr 2006 09:17:40 -0700
Message-ID: <1144685860.909960.286080_at_i39g2000cwa.googlegroups.com>

Firstly, not sure where to post this so I hope I this is the right place, I am a bit of a rookie at this so any help would be great!...

I need to build a simple CRM database, and I am struggling with the following:

Clients can be either people or companies (companies and people have some different attributes but share a lot too, like name, address, etc.). Each client has one or more accounts. So I guess my question is... how do I link the accounts to the two different client types
(company vs. people)? Should I have one "contact" table that holds
generic data about both a company or a person (doesn't seem right to me

for some reason) or is their a way to create a client table with two subordinate tables, one for each client type?

I also need to store the relationships that people have to other people

(i.e. father, uncle, consulant, etc...) and the relationships between
firms (i.e. vendor, etc.). How is a many-to-many relationship table constructed?

THANKS! Grant Received on Mon Apr 10 2006 - 18:17:40 CEST