Question

What is the need for database normalisation?

Answer 1

Normalisation is a process to manage and stabilize the data in the data base so that the consistency and integrity of data can be maintained easily as well as the redundancy of data can also be minimized.

Need :- Data normalisation helps you design new databases to meet these goals or to test databases to see whether they meet the goals. Sometimes database designers refer to these goals in terms such as data integrity, referential integrity, or keyed data access. Ideally, the data is normalised before creating database tables.