C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...
New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !




Database Normalization


Posted Date: 27 Sep 2008    Resource Type: Articles    Category: Databases
Posted By: Athira Appukuttan       Member Level: Diamond
Rating:     Points: 4



Normalization:

It is a process used to remove the ambiguities and inconsistencies that may exists int the
schema derived from ERPs.
Also through Normailzation we avoid unnecessary duplication of data.

Types of Normalization:

First Normal Form:

A table is said to be in first normal form,provided the insersection of every row and cloumn conatin only atomic value:
Meand by setting primary key ,we can avoid the duplication in our table.

Second Normal form:
A table is said to be in 2NF provided it is in 1NF and
every non key column is fully functionally dependent on candidate key.
Meand through setting the foreign key relationship we can avoid the duplication

Third Normal form:
A table is sai9d to be in 3NF provided it is in 2NF and every non key column is non transitively
dependent on Candidate key.

fourth Normal form:

Another name is Boyce-Codd Normal Form(BCNF)
A table is said to be in BCNF,provided it is in 3NF and there are no overlapping candidate key.It is also referred to a strong 3NF



Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks      
Popular Tags   What are tags ?   Search Tags  
Database Normalization  .  

Post Feedback


This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.
Next Resource: Types of stored procedures
Previous Resource: Cursors in SQL:
Return to Discussion Resource Index
Post New Resource
Category: Databases


Post resources and earn money! 		 
Related Resources


dotNet Slackers   BizTalk Adaptors    Web Design

doors in nj

Contact Us    Privacy Policy    Terms Of Use