-
Junior Member
How many normalization forms exists
How many are the levels / forms of normalizaion exists?
also how much normalization should be done?
-
Expert Member
Re: How many normalization forms exists
The process of normalization breaks the data into smaller tables to reduce redundancy and make retrieving and managing that data more efficient. There are mainly 5 Normalization rules. In most of the cases we use first three normalization rules only.
1 Normal Form : A table is said to be in 1st Normal Form when the attributes are atomic
2 Normal Form : A table is said to be in 2nd Normal Form when all the candidate keys are dependant on the primary key
3rd Normal Form : A table is said to be third Normal form when it is not dependant transitively (when one non-key attribute is functionally dependent on another non-key attribute)
Last edited by krishnaindia2007; 01-03-2008 at 08:12 AM.
-
Re: How many normalization forms exists
actually there are 7 but only 3 are used
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules