What is normalization and how are use normalization in database table?

Asked By sonu11 0 points N/A Posted on - 03/12/2012

What is normalization and how are use normalization in database table?

• Status: Open
• Question Views: 1064
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: dBase

Answered By Sharath Reddy 590495 points N/A #127345

What is normalization and how are use normalization in database table?

The process of effectively organizing data in a database is called Normalization. It has 2 goals: eliminating or removing unnecessary data, and guaranteeing data dependencies make sense. Both of these are worthy goals as they reduce the amount of space a database consumes and ensure that data is logically stored.

The database community has developed a series of guidelines for ensuring that databases are normalized. These guidelines are called normal forms and are numbered from 1 to 5. The first is the lowest form of normalization and is referred to as first normal form or 1NF. The highest is 5 and referred to as fifth normal form or 5NF. In practical applications, you'll often see 1NF, 2NF, and 3NF along with the occasional 4NF. The fifth normal form is very rarely seen. For more information about this, you may visit Database Normalization Basics.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 10/10/2012
• Question Category: dBase