Russell,
I am contemplating a Historical Database
I barely can spel redundant let alone normalize so I am handicapped.
The aim is to enter a name only once. I am studying linking tables.
In the [Contact]
idContact
First_Name,Last_Name,Middle,Suffix,Full_Name,idCity,idState,City_State,i
Wow I'm amazed and thankful for such help and advice
I thought I would attack this project piecemeal but that will not give a
clear view that will allow helpful comment without the full view.
I have a website at http://geocities.com/efoxfiles a labor of love
So now it has become so detail
Thanks for the advice
So reflecting what advice I have received to date:
Assuming that the Contact table would be used for:
Owners, Breeders, Sportsmen, Ancestors, Associations, and a myriad of
other categories of mankind, would the following normalization be
prudent?
ContactID
Not so sure you need to go to that much detail in the linking of your
tables. It's a good idea for the states, but the zip is usually just an
integer anyway, so you can just store that with the record. Next, do
you really need Full_Name??? You can extract that from the other two
fields. As