Forum

Notifications
Clear all

What is normalization in dbms?


Vikky
Posts: 47
 Vikky
Topic starter
(@Vikky)
Joined: 11 months ago

Hi

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

1 Reply
VK
Posts: 17
 VK
(@vinodkrsetty5895)
Active Member
Joined: 11 months 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. 

Here are is the complete guide with practical examples.

 

Reply
Share: