среда, 13 февраля 2013 г.

SQL Normal Forms


First Normal Form (1NF) sets the very basic rules for an organized database:
Eliminate duplicative columns from the same table.
Create separate tables for each group of related data and identify each row with a unique column (the primary key).

Recall the general requirements of 2NF:
Remove subsets of data that apply to multiple rows of a table and place them in separate tables.
Create relationships between these new tables and their predecessors through the use of foreign keys.


There are two basic requirements for a database to be in third normal form:

Already meet the requirements of both 1NF and 2NF
Remove columns that are not fully dependent upon the primary key.


Visual_C_Sharp_2008 Poster

http://www.microsoft.com/en-us/download/confirmation.aspx?id=7162