|
bobby -> RE: database design (11/17/2004 11:51:34)
|
Normalizing is a pain in the butt... not fun at all, but once you figure it out it's not as daunting as it seems.
It's been a while since I took a workshop on db design... but the reason for the foreign keys (if memory serves) is because you have a many to many relationship between two tables that needs a junction table to normalize.
I would strongly suggest picking up a book or taking a class on database design, rationalization and normalization... it's not an easy subject to explain easily...
I took a one day class (workshop) at a local CC. It was an 8 hour class and cost me about $100. It was the best thing I could have done. (It was actually part two of a five class workshop on web dev. using Frontpage)
[;)]
|
|
|
|
