[AccessD] Normalization discussion

<jamesbutton at blueyonder.co.uk> wrote:

> And I would include a searchable comments field on many of the entries so
> you
> can include a short set of notes - such as a "See documents in folder ___"
> Also consider that many of the 'acquired from' places will probably not
> exist,
> or have moved shortly after you get the animals from them - otherwise why
> would
> they not keep the animals
>

==========We're an educational nature center. Everything here is native to
Kentucky. Mostly, they're wildlife that can't be released to the wild and
they come via rehabbers and rescues. Many of those places are well
established, but you're right, they won't always be there, but that would
be true of any business.


>
>
> And - will you be getting offspring from them - that will lead into a
> whole new
> concept of hierarchical entries for descendents of descendents of ...
>

===========I'll be using a self-join for those.

>
> Think of the entries if you're breeding mice - or spiders!
>
> ===========No spiders or insects here, although we do have a few
collections (all dead fortunately). Few of the animals here are allowed to
procreate -- the elk, bison, deer, turkeys, and quail.

Susan H.