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
================================================== =========