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
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
dZip_Code,
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