normal form : Java Glossary

home page go to the Java Glossary Home go to the Computer Buyer’s Glossary up jump to foot of page Google search web for more information on this topic Pinterest pin button
* 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-2017 Roedy Green of 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.

This page is posted
on the web at:

 http://mindprod.com/jgloss/normalform.html

Optional Replicator mirror
of mindprod.com
on local hard disk J:

 J:\mindprod\jgloss\normalform.html
Canadian Mind Products
Please the feedback from other visitors, or your own feedback about the site.
Contact Roedy. Please feel free to link to this page without explicit permission.

IP:[65.110.21.43]
Your face IP:[3.15.1.209]
You are visitor number