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

Posted by Rajesh123 under Oracle on 7/30/2015 | Points: 10 | Views : 459 | Status : [Member] | Replies : 4
Hi Friends can we please explain normalization with examples.

rajesh.plsql123@gmail.com


Responses

Posted by: Shreedar on: 8/15/2015 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Rajesh123 on: 8/19/2015 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Shreedar on: 8/20/2015 [Member] Starter | Points: 25

Up
0
Down
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

Posted by: Pankajchoudhary on: 8/21/2015 [Member] Starter | Points: 25

Up
0
Down
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

Login to post response