What is normalization? Explain normalization types.

Question Posted / ashishonline12345

2 Answers
8551 Views
Lehman Brothers, SKS Microfinance, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is normalization? Explain normalization types. ..

Answer / ashishonline12345

Database normalization is the process of changing a
relational database structure to be the most efficient for
the particular purpose. The most commonly known form
is “Third Normal Form”, which allows for zero duplicate
data, except for foreign keys.

Is This Answer Correct ?

11 Yes

2 No

What is normalization? Explain normalization types. ..

Answer / guest

Database normalization is the process of organizing the
fields and tables of a relational database to minimize
redundancy and dependency. Normalization usually involves
dividing large tables into smaller (and less redundant)
tables and defining relationships between them. The
objective is to isolate data so that additions, deletions,
and modifications of a field can be made in just one table
and then propagated through the rest of the database via the
defined relationships.

1 NF:Normal Form
2 NF
3 NF
BCNF - Boyce Code Normal Form
5 NF
6NF : Impossible to achieve this level of normalization

Is This Answer Correct ?

4 Yes

1 No

Post New Answer