Question

  Asked: Sep 18 2007   7:05 AM GMT
  Asked by: 98275


what is normalization


Normalization

what is normalization

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



Bacially it is when you create a database and organize it into tables to get consistent results. You can see the Whatis.com definition here
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Oracle.

Looking for relevant Oracle Whitepapers? Visit the SearchOracle.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Rmgulati  |   Sep 26 2007  3:14PM GMT

Normalization is a process of decomposing a table losslessly into various tables inorder to remove Insert/Update/Delete anamolies, if any in the given table. There are various Normal forms like First Normal Form (1NF), 2NF, 3NF, BCNF, 4NF and 5NF

 

Timd  |   Sep 27 2007  12:42PM GMT

Hi: Here are some resources for further reading about normalization…

What is normalization?
<a href="http://searchoracle.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid41_gci1219510,00.html" rel="nofollow">http://searchoracle.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid41_gci1219510,00.html</a>

Learning Guide: RDBMS fundamentals
<a href="http://searchoracle.techtarget.com/generic/0,295582,sid41_gci1087688,00.html" rel="nofollow">http://searchoracle.techtarget.com/generic/0,295582,sid41_gci1087688,00.html</a>

More:
<a href="http://searchoracle.techtarget.com/search/1,293876,sid41,00.html?filter=on&query=normalization&ctype=ALL&anum=&within=text&psrc=SSM" rel="nofollow">http://searchoracle.techtarget.com/search/1,293876,sid41,00.html?filter=on&query=normalization&ctype=ALL&anum=&within=text&psrc=SSM</a>

Good luck, Tim