What is normalization in dbms?

Last Post

RSS

Posts: 47

Vikky

Guest

Topic starter

Sep 13, 2020 3:24 pm

(@Vikky)

Eminent Member

Joined: 4 years ago

What is the normalization in DBMS and what is the purpose of it?

Topic Tags

normalizationindbms normalization

1 Reply

Posts: 18

Sep 17, 2020 4:38 pm

(@vinodkrsetty5895)

Active Member

Joined: 4 years ago

Normalization is a processes of splitting larger set of tables into smaller tables to reduce redundancy in the database (duplicate data).

It avoid insert, update and delete anomaly problems.

It can also avoid null values in the tables.

Normalization Improves the performance of queries.