Forum

Share:
Notifications
Clear all

What is normalization in dbms?

2 Posts
3 Users
0 Likes
615 Views
Vikky
Posts: 47
 Vikky
Guest
Topic starter
(@Vikky)
Eminent Member
Joined: 2 years ago

Hi

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

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

Here are is the complete guide with practical examples.

 

Reply

Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Saved
Share: