Hudzilla.org - the homepage of Paul Hudson
Contents > Databases > Normalisation Wish List | Report Bug | About Me ]

9.8.6     Other normal forms

This is NOT the latest copy of this book; click here for the latest version.

Beyond 2NF, there is third normal form (3NF), Boyce-Codd Normal Form (BCNF), as well as 4NF and 5NF - they become increasingly complex with each iteration, and the end result is usually not overly different from 2NF. This book is about PHP, so there is not room to go in any more detail, however there are dozens of books on database theory that would help you out if you wanted to learn more.

Generally speaking, you're best off with 2NF.





<< 9.8.5 Second normal form   9.8.7 Conclusion >>
Table of Contents
Want to see this stuff in print? PHP in a Nutshell takes the core topics covered here, adds in thousands of edits from the editorial team and myself, and combines them to make an unbeatable reference for PHP programmers at all levels.



My latest book has hundreds more tips on how to use PHP, Apache, and MySQL, plus Perl, Python, shell scripts, performance tuning, and more!



Top-right shadow
 
Bottom-left shadow Bottom shadow

Comments from other readers
Be the first to add a comment to this chapter!



Add comment
Please note that by posting a comment here you are committing it to the public domain. This is important so that others can make use of your code themselves, and also so that I can incorporate helpful notes directly into the main text. Comments are limited to 2000 characters in length.

If you are reporting an error in the content, please tell me directly.

Your name/email address:
Your comment:
 
Now, in order to verify that you're a real person, please answer this simple question: what is three plus four?
The answer is:
(please write in
numbers, eg 19)


Top-right shadow
 
Bottom-left shadow Bottom shadow