[AccessD] Another normalization question

Bill Benson bensonforums at gmail.com
Tue Sep 16 17:35:36 CDT 2014


Hence business entity all those and a business entity type can be in a
businessentity table. At least in some databases.
On Sep 16, 2014 5:48 PM, "Stuart McLachlan" <stuart at lexacorp.com.pg> wrote:

> Some phone numbers belong to positions, others belong to people and yet
> others belong to
> the whole institution. You should  differentiate them.
>
> Think about it as:
>
> Institution:  Inst Name, Address, Switchboard Phone #
>      Position - Posn Name, Bus Phone # etc
>          Person - , Pers Name, Pers Phone #, email etc
>
> Institution/Person is one-to-many
> Position/Person is potentially many-to-many
>
>
> --
> Stuart
>
> > one contact and each has a number? On the other hand, if I relate the
> > phone number to the contact and the contact leaves, I lose the phone
> > number, which might rightly belong to the institution.
> >
> > You know, looking back... I can't remember how I handled this in the
> > past.
> >
> > Susan H.
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list