normal form : Java Glossary

home page go to the Java Glossary Home go to the Computer Buyer’s Glossary up 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-2012 Roedy Green, Canadian Mind Products
normal form
In SQL (Standard Query Language), 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.
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
logofeedback Please email your feedback for publication, letters to the editor, errors, omissions, typos, formatting errors, ambiguities, unclear wording, broken/redirected link reports, suggestions to improve this page or comments to Roedy Green : feedback email If you want your message kept confidential, not considered for posting, please explicitly specify that.
mindprod.com IP:[65.110.21.43]
view BlogYour face IP:[38.107.179.211]
You are visitor number 9,424.