Prestwood: Learn the Three Normal Forms in One Sentence (DBA, Databases, & Data)

DBA

	DBA Group Home
Get Started Page eMag: DBA Edition Highlights WEEKLYLESSON Week 20 Lesson MYGROUPSETTINGS My Group Settings

	Message Board
-New Activity -Unanswered Threads -Most Active Threads -Most Read Threads

	DBA KB
-New & Updated -Most Read -10 Min Quickstarts -Recent Comments Tech Articles DBA News Errors Library File Library Resource Links DBATIDBITS: All as FlashCards Code Snippets FAQs Tips Terms & Definitions

	DBA Store
PRESTWOODSTORE Store Home Buy DBA Items

	Members Only
MEMBERSONLY DBA Member List Member Only KB Posts DBA Content Stats Random Article Random MB Thread Random Tidbit

Prestwood eMagazine

May Edition

Subscribe now! It's Free!

► KB ► Role-Based T... ► DBA & Data

Print This

Go To Random Article

From the February 2013 Issue of Prestwood eMag

DBA & Data:

Learn the Three Normal Forms in One Sentence

By Mike Prestwood

Posted 6 years ago on 6/23/2007

Take Away: The three normal forms can be summed up in the following phrase: All the fields of a table should relate to the key, the whole key, and nothing but the key.

A flashcard from our DBA Flashcards Library

A tip from our DBA Tips Page

The three normal forms can be summed up in the following phrase: “All the fields of a table should relate to the key, the whole key, and nothing but the key.”


Comments 1 Comments. Share a thought or comment...

JeanWM

Comment 1 of 2

I use the following phrase: “All the fields of a table should relate to the key, the whole key, and nothing but the key. So help you Codd”

Posted 16 months ago

Mike Prestwood

Comment 2 of 2

So help you Codd, that's awesome!

Posted 16 months ago

Tip Contributed By Mike Prestwood:

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

KB Article #100597 Counter

4830

Since 4/2/2008

Prestwood eMagazine

Comments