Join Dotnetcodes is online Discussion Forum for Software professionals . It lets you find friends around the world and Create professional network that share similar interests as you. Get help on ur projects by industry specialists. Also get answers to all ur technical/placement related querries.Get an edge over others.
Already MemberClick here to login MVC Interview Questions Answers Interview Questions
Serial Number in SSRS Articles
Get Started Developing for Android Apps with Eclipse Articles
How to Print a Crystal Report direct to printer Articles
Razor View Engine Interview Questions Answers Interview Questions
.Net framework 4.0 Interview Questions Answers Interview Questions
SQL server reporting services Interview Questions (SSRS) part 1 Articles
Whats New in ASP.NET 4.0 Part 2 Articles
Difference between Encapsulation and Abstraction Interview Questions
Explaining SDLC -System Development Life Cycle Articles
SPIRE PDF Library Articles
Infosys Interview Questions Interview Questions
Html5 interview questions and answers Interview Questions
Dynamic Menu using HTML List Tag and CSS in ASP.Net Articles
SharePoint 2010 interview Questions Answers Interview Questions
Submit Articles | More Articles..


Posted By: rounaksinh On:8/2/2010 6:06:16 AM in:Articles Category:Sql Server Hits:1829
what is Normallization in sql2005

What is Normalization

Normalization is the process of designing a data model to efficiently store data in a database.
The end result is that redundant data is eliminated, and only data related to the attribute
is stored within the table. So we can say that normalization is the chain of steps and this chain of
steps take a relation from one Normal Form State to another Normal Form State until we get to the
desired Normal Form State.
There are six different normalization methods as follows:
(1) 1st Normal Form: Each field in a table contains different information. 
For example, in an employee list, each table would contain only one employee id field.
(2) 2nd normal Form: Each field in a table that is not a determiner of the contents of another
field must itself be a function of the other fields in the table.
(3) 3rd Normal Form: We say that a relation is in 3NF if it is in 2NF and has no transitive dependencies.
 (4) Boyce-Codd Normal Form: also known as BCNF A relation is said to be in BCNF if and 
only if every determinant in the relation is a candidate key.
(5) 4th Normal Form: A relation is said to be in 4NF if it is in BCNF and contains no multi valued attributes.
(6) 5th Normal Form: A relation is said to be in 5NF if and only if every join dependency in relation is
implied by the candidate keys of relation.
(7) Domain key normal Form: We say that a relation is in Domain Key Normal Form (DKNF) if it is free of all 
modification anomalies. Insertion, Deletion, and update anomalies come under modification anomalies.
comments powered by Disqus
User Profile
Rounak Kumar Sinha
Software Developer(Eng.)
Ranchi , india
Email :You must Log In to access the contact details.
Latest Post from :rounaksinh
View: 1829 | Submitted on: 8/2/2010 6:06:16 AM
Submit Articles | All Post of This User..

Advertise About Us Private Policy Terms of use
All rights reserved to dotnetcodes. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks.
Best viewed at 1024 x 768 resolution with Internet Explorer 5.0 or Mozila Firefox 3.5 or Google Crome and higher