what is normalisation

Answer 1

Normalization is the process of organizing a database in such a way that reduces data redundancy and ensures data integrity. It involves breaking down a large table into smaller tables and defining relationships between them, to minimize data redundancy and ensure no data is unnecessarily duplicated. This process helps to optimize database performance and make it easier to maintain and update the data.