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 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) ©1996-2009 Roedy Green, Canadian Mind Products
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 You can get the freshest 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
CMP logofeedback Please email your feedback for publication, errors, omissions, typos, formatting errors, ambiguities, unclear wording, broken/redirected link reports, suggestions to improve this page or comments to Roedy Green : feedback email
mindprod.com IP:[65.110.21.43]
view BlogYour face IP:[38.107.191.109]
You are visitor number 8,052.