[AccessD] This seems to get me often

The donation table contains donation, amount, date, donorID, perhaps type
of donation (i.e. pledge, lump sum, in kind, etc.).  You have a persons
table that includes a field for companyID because you probably want to
address any thank yous to that person's attention at their company, if
any.  The Company table is just that, companies.  It may have multiple
addresses so those are linked to the persons table.  If you put contacts
into the company table, you will either wind up overwriting the contacts
for future donations, or you'll have duplicates of the company for
different contacts.  The persons and companies table have addresses in an
Address table whose PK is inserted as an FK in the appropriate table.  Does
that seem any clearer?


Charlotte

On Tue, Dec 23, 2014 at 4:48 PM, Susan Harkins <ssharkins at gmail.com> wrote:

> A donor can be an individual or an organization -- they're all donors.
> Donor is the entity, the name and type of donor all belong to donor. Right?
>
> Susan H.
>
> On Tue, Dec 23, 2014 at 7:36 PM, Charlotte Foust <
> charlotte.foust at gmail.com>
> wrote:
>
> > ​Not without denormalizing the table.
> >
> > Charlotte​
> >
> > On Tue, Dec 23, 2014 at 4:32 PM, Susan Harkins <ssharkins at gmail.com>
> > wrote:
> >
> > > Is there anyway to have orgs and individuals in the same table?
> >
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>