What is normalization,where can i use in realtime and explain this?

Hi

Normalization means breaking the large tables in to small tables to remove redundancy( duplicate data) , inconsistency of data.

This can be done with some rules and regulations by using constraints like primary key, foreign key, unique key etc..

You can apply these in real time when you create tables in your database.

My suggestion for you is to learn the normalizations atleast below of these.
1st, 2nd and 3rd Normalizations.

Mark as answer, if you are satisfied.

Regards,
Sridhar Thota.

Regards

Sridhar Thota.
www.dotnet-sridhar.blogspot.com

Rajesh123, if this helps please login to Mark As Answer. | Alert Moderator

Hi Sridhar
thank you for your response my question.
if you don't mind can you explain different types of normalisations and at which situation we are using these Normalisation.

rajesh.plsql123@gmail.com

Rajesh123, if this helps please login to Mark As Answer. | Alert Moderator

Hi Rajesh.

1NF: First Normalization says that each column should contain one value and each
row should contain same number of columns.
Implement primary key to identify the records uniquely.

2NF: Second Normalization says move redundent data to separate table.
Use foreignkey contraint between two tables.

3NF: Third Normalization says it should be in 1NF and 2NF to be a 3NF.
Table should not contain columns which are not fully dependent on primary key.

Mark as answer, if you are satisfied.

Regards

Sridhar Thota.
www.dotnet-sridhar.blogspot.com

Rajesh123, if this helps please login to Mark As Answer. | Alert Moderator

Database normalization is the process of organizing the attributes and tables of a relational database to minimize data redundancy. normalization is the process of organizing it into tables in such a way that the results of using the database are always unambiguous and as intended. Normalization may have the effect of duplicating data within the database and often results in the creation of additional tables. (While normalization tends to increase the duplication of data, it does not introduce redundancy, which is unnecessary duplication.)

Rajesh123, if this helps please login to Mark As Answer. | Alert Moderator