Normalization and denormalization

Question Posted / katta_s

3 Answers
6933 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Normalization and denormalization..

Answer / vishnu

In relational Database design, the process of organizing
data to minimize redundancy is called Normalization.
Normalization usually involves dividing a database into two
or more tables and defining relationship b/w the tables.
1) 1st NF: Eliminate Repeating Group(Column)
2) 2nd NF: Eliminate Redundant Data
3) 3rd NF: Eliminate Columns Not dependent on Primary key
4) 4th NF: Isolate Independent Multiple Relationships
5) 5th NF: Isolate Semantically Related Multiple Relationships

De-normalization is the process of attempting to optimizing
the performance of a database by adding redundant data. It
is sometimes necessary bcoz current DBMSs implement the
relational model poorly. its a technique to move from higher
to lower normal forms of database modeling in order to speed
up database access.

Is This Answer Correct ?

6 Yes

0 No

Normalization and denormalization..

Answer / sakthi

Normalization:
Process of decomposing a longer table into
smaller one, by using normalizaton we can fetch the data
faster. there are different types of normalization below
listed are few important one.

1) 1st normal form
2) 2nd normal form
3) 3rd normal form
4) 4th normal form
5) 5th normal form

Is This Answer Correct ?

2 Yes

0 No

Normalization and denormalization..

Answer / pragyan

database normalization is a data design and organization process applied to data structures based on rules that help building ralational databases.and usually it involves dividing a database into two or more tables and defining relationships between the tables.

de-normalization is the process of attempting to optimize the performance of a database by adding redundant data..

Is This Answer Correct ?

1 Yes

0 No

Post New Answer