The process of efficiently organizing data in a
database. There are two goals of the normalization
process:
– eliminating redundant data (for example, storing the
same data in more than one table) and
– ensuring data dependencies make sense (only storing
related data in a table).
• Both of these are worthy goals as they reduce the
amount of space a database consumes and ensure
that data is logically stored.
• Normalization is a method to remove all these
anomalies and bring the database to a consistent
state.