Discuss the three goals of normalization.

What will be an ideal response?

Normalization has three goals. First, normalization reduces the space required to store data by eliminating duplicate data in the database (with the exception of duplicate data in the foreign key fields). Second, normalization reduces inconsistent data in the database by storing data only once, thereby reducing the chance of typographical, spelling, and transposition errors and other inconsistent data possible in flat file databases. Finally, normalization reduces the chance of deletion, update, and insertion anomalies.