Answer to Question #266611 in Databases | SQL | Oracle | MS Access for Prem

Question

Explain briefly about the need of normalization.

Answer 1

Normalization is a database design technique that reduces data redundancy and eliminates undesirable characteristics like Insertion, Update and Deletion Anomalies. Normalization rules divides larger tables into smaller tables and links them using relationships. The purpose of Normalisation in SQL is to eliminate redundant (repetitive) data and ensure data is stored logically.

Source: https://www.guru99.com/