3 Normal Forms in Relational Database Theory

7 February, 2011 at 2:58 pm Leave a comment

I find this guide easiest to understand:

First normal form (no items appear more than once)

  1. each col must have a unique name
  2. order of rows and cols doesn’t matter
  3. each col must have a single data type
  4. no 2 rows can contain identical values
  5. each col must contain a single value
  6. cols cannot contain repeating groups

Second normal form (primary key determine value of other columns)

  1. in 1NF
  2. all non-key fields depend on all of the key fields

Third normal form (value not determined by any non-primary key)

  1. in 2NF
  2. contains no transitive dependencies (when one non-key field’s value depends on another non-key field’s value)

Source: from Beginning Database Design Solutions (Rod Stephens)

Entry filed under: IT/Soft.

Tác giả Ngô Phan Lưu Kohaku River

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed

February 2011

%d bloggers like this: