The purpose of normalization is to reduce the chances for anomalies to occur in a database.
The Normalization also forces you to use a database in a Object orientated manner. (This is good of course.)
Chat with our AI personalities
There are many advantages of performing a database normalization. Some of the advantages include faster index searching, data commands are faster with less indexes and a more compact database with less null data.
Normalization is a process of reducing redundancies of data in a database. If you don't normalize you will have to repeat data entry.
Normalization is 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.
Un-normalization of data will return the actual values of outcome, which is real value. Because we scale the data in normalization process.
amit raj