Programming Index Cards

June 25, 2008

1-2-3 Normal forms

Filed under: database, database design — Tags: , , , — apcig @ 7:35 pm

1st Normal Form – Eliminate Repeating Groups (ERG)
all occurrences of a record type must contain the same number of fields. No sets

2nd Normal Form – Eliminate Redundant Data (ERD)
violated when a non-key field is a fact about a subset of a key.

3rd Normal Form – Eliminate Columns Not Dependent on Key (ENDK)
violated when a non-key field is a fact about another non-key field.

All normal forms are additive.

Source

No Comments Yet »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a comment

Blog at WordPress.com.