View Single Post
  #9 (permalink)  
Old March 26th, 2008, 11:07 AM
dparsons dparsons is offline
Wrox Author
Points: 13,255, Level: 49
Points: 13,255, Level: 49 Points: 13,255, Level: 49 Points: 13,255, Level: 49
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2005
Location: Ohio, USA
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

I think this is one of those topics where you are bound to have varying degress of opinions but I am always up for a well educated discussion.

While Woody makes the argument that City is reliant on the Primary Key value in the table I would tend to disagree. Can't you make the argument that its a transitive relationship because the city (presumably the city where the person lives) relies on the FullName which then relies on the Primary Key?

Further I think the overall question is from a practical standpoint (e.g. application development) what is functional. I am sure Codd would utterly rip me apart if he saw some of my Database designs but there comes a point that if you normalize to far your application preformance can suffer because of the Joins necessary to get a "complete" record.

-Doug

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========
Reply With Quote