[ganesh15]

Is there any advantage to normalizing beyond third normal form? Why or why not?

-ganesh

[andrewst]

Originally posted by ganesh15
Is there any advantage to normalizing beyond third normal form? Why or why not?

-ganesh

For most tables, when you get to 3rd normal form you are done. 4th and 5th normal form relate to composite keys.

Here is a tutorial on the subject - it's fairly complex to try to address here.

http://hive.cs.uwyo.edu/~jthomson/db4&5/sld001.htm