Like This Site? 
 
RSS Feed Follow Us 

on Twitter! Be Our Fan!

First Normal Form In Detail

Share this post!
 Vote this!

Since all non-trivial websites require a database, and since database skills are different from coding skills, there is very good reason for any programmer to master the principles of database design and use.

The most basic skill that you need for successful database projects is table design. A strong table design can be the foundation of a wonderful application, while a weak design brings nothing but delays, expense, headaches and heartaches.

One of the cornerstones of good table design is the process of normalization. Normalization proceeds through different stages. The result of each stage is called a "Normal form." So if we have completed the first stage we say the database is in "First Normal Form", and after we have completed the second stage we say the database is in "Second Normal Form" and so on.

More...

RECOMMENDED READING

Second Normal Form 

Third Normal Form and Calculated Values

0 comments:

Post a Comment