[AccessD] Another normalization question

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
>