What is normalization in databases?
Why is it important?
- Normalization is the process of organizing the data in a database to reduce
redundancy and dependency by dividing large tables into smaller ones and linking
them with relationships.
Importance:
- Reduces Data Redundancy: Ensures data is only stored once.
- Improves Data Integrity: Ensures consistency and correctness of data.
- Simplifies Updates: Easier to maintain and modify data without affecting the
entire system.