[AccessD] Another normalization question

I really like Mark and Bill's solution for this simple database -- I'm going
to drop a new fk in and add "personal" to the type description. Well, that's
my plan -- we'll see how it fits tomorrow. I really appreciate all the help.
Thank you!

Susan H. 

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