[AccessD] Normalization discussion

Susan Harkins ssharkins at gmail.com
Fri Aug 29 08:07:25 CDT 2014


I'll spend the morning rereading the book Martin and I wrote, brushing up
on the normalization part. I've forgotten a lot of the basics. I'm writing
an animal tracing database in Access and I'm trying to remember if it
matters where the fk goes. Now, I remember its purpose and all that, but it
would be so much simpler if I could just drop them all into the main table
instead of adding a fk to all the child tables to the main table -- I think
anyway.

So, I've got a main table of animals and all of the remaining tables are
child tables of a sort and a few lookup tables. Is it reasonable to just
add a fk to all those child tables in my parent table?

I just don't remember. I haven't built a database in... seriously... 10
years? It's been long enough that I'm really struggling.

Susan H.


More information about the AccessD mailing list