Database Normalisation Questions
The process of normalization in database design is a technique used to organize and structure a database in order to eliminate redundancy and improve data integrity. It involves breaking down a database into multiple tables and applying a set of rules called normal forms to ensure that each table contains only relevant and non-redundant data. The goal of normalization is to minimize data duplication, improve data consistency, and enhance overall database performance.