Hello all,
I am looking at developing a Contacts database. In some of
the projects I've done, there seemed to be mainly a 1 to many
relationship in the database tables. So, my question is a SQL issue.
With regard to a Contacts Database there will be individual persons
and Companies/Organizations/etc. I might even want a field for the
type of organization, e.g. company, non-profit, church, etc.
1) So, a company can have many employees, owners, etc, that can be in
the database.
2) I would only want to have those employees or members of an
organization recorded in the database if the individuals are also in
the Database...
Thus,
1) Organizations can have employees or members that are also
individuals in the contacts database.
2) Individuals can be part of one or more organization.
3) It's not desirable or a good design to have in the Organization
table, each employee or member of the organization... instead we need
to have a common field shared by this database that links these tables.
4) Individuals can have more than one affiliation. Hence the common
field would be used to link these tables.
Am I thinking this through correctly? This is a many to many
relationship correct?
Tips anyone?
Can someone offer tips or guidance on how I can learn more about
topics of this nature?
Thanks,
Bruce
