You might learn databases in your academics, you heard and read the term normalization but probably we might not apply normalization in practical. Please go thru my practical approach on Database Normalization. This article is not yet completed completely but here is some of the stuff to you…………
What is Normalization?
Normalization is a process of efficiently organizing the data in a database. In another way normalization is a rule to be applied on the Database and get more benefits.
Normalization is “designing the Database in a structural format.”
Goals of Normalization:
The primary goals of the normalization is
1. Eliminating redundant Data
2. Make sure that the database dependencies make sense ( Relation between database are viable)
Benefits of achieving the Primary goals of Database Normalization
There are so many benefits once you have applied normalization on Database. More precisely you come to know the actual benefits only you have practical experience on the Normalized and De Normalized Database. But I can explain you the maximum number of benefits during my entire article on Database Normalization.
Some of the benefits are
1. Reduce the amount of space that the Database consumes
1. Make the Database design easy
2. Make the Database easier to maintain
3. Make sure the Database is in structural way
4. Prevents the Database from various update anomalies which can occur in un normalized Databases
5. Preventing the need to restructure existing tables to accommodate new data
6. Enable record processing by simple operators
7. Less null values and less redundant data, making your database more compact.
8. Triggers execute more quickly if you are not maintaining redundant data
9. Increased speed and flexibility of queries, sorts, and summaries.
[I will back with more stuff (Stay Tuned….)]
