normal form : Java Glossary

home page go to the Java Glossary Home go to the Computer Buyer’s Glossary up 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
logo
Please email your , 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, your name or email kept confidential, not considered for public posting, please explicitly specify that. Unless you state otherwise, I will treat your message as a letter to the editor that I may or may not publish in the feedback section. After that, it will be too late to retract it. If you disagree with something I said, please quote it and cite the web page where you found it, tell me why you think it is wrong, and, if possible, provide some supporting evidence. Threatening to kill me or spouting obscenities has yet to persuade me to change my mind.
mindprod.com IP:[65.110.21.43]
view BlogYour face IP:[38.107.179.213]
You are visitor number 9,566.