normal form : Java Glossary

go to home page N words local find full screen, hide local find menu Google search web for more information on this topic jump to foot of page translate this page with Babelfish by Roedy Green ©1996-2009 Canadian Mind Products
index page for letter ⇒ punctuation 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z (all)
normal form
In SQL, there are five rules of sensible database design called the five normal forms. Briefly they are:
  1. No repeating groups of data within a row. Instead of having an Author1, Author2 and Author3 field, you should put the Author information in a separate table.
  2. Every non-key item must depend on the entire primary key. Don’t replicate data that depends only on part of the key.
  3. Each non-key item must be a fact about the primary key item, not some other non-key item.
  4. Don’t mix two different one to many relationships in the same table.
  5. Break tables up as small as possible so that each fact is recorded in only one place in the database. In practice, you have to balance this general rule against the extra overhead of many small tables.
list of available newsreaders
CMP homejump to top
CMP logo		 feedback Please email your feedback for publication, errors, omissions, broken/redirected link reports
and suggestions to improve this page to Roedy Green : feedback email
made with CSS
HTML Checked!
ICRA ratings logo
mindprod.com IP:[65.110.21.43]
Your face IP:[38.103.63.58]
You are visitor number 7,643.
You can get a fresh copy of this page from: or possibly from your local J: drive (Java virtual drive/mindprod.com website mirror)
http://mindprod.com/jgloss/normalform.html J:\mindprod\jgloss\normalform.html