Skip to toolbar

Forum

Notifications
Clear all

What is normalization in dbms?  


Vikky
Posts: 42
 Vikky
Guest
(@Vikky)
Joined: 4 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: 4 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

Leave a reply

Author Name

Author Email

Title *

Maximum allowed file size is 10MB

 
Preview 0 Revisions Saved
Share: