[AccessD] Normalization discussion

Hi Susan

Good to see you back on the horse!

I'm not "strong in animals" so I hardly can add anything that you can't read in the book.

/gustav

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Susan Harkins
Sendt: 29. august 2014 15:07
Til: Access Developers discussion and problem solving
Emne: [AccessD] Normalization discussion

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.