top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

What is Normalization in Oracle?

+1 vote
What is Normalization in Oracle?
posted Oct 17, 2014 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

+1 vote
Best answer

Normalization is the process of organizing the tables to remove the redundancy.

There are mainly 5 normalization rules.

a) 1 Normal Form : A table is said to be in 1st Normal Form when the attributes are atomic
b) 2 Normal Form: A table is said to be in 2nd Normal Form when all the candidate keys are dependent on the primary key
c) 3rd Normal Form : A table is said to be third Normal form when it is not dependent transitively

answer Oct 20, 2014 by Arun Gowda
+1 vote

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. There are several benefits for using Normalization in Database.
Types of Normalization are as follows:
 First Normal Form
 Second Normal Form
 Third Normal Form
 Boyce’s Normal Form
 Fourth Normal Form
 Fifth Normal Form

answer Nov 15, 2014 by Manikandan J
Contact Us
+91 9880187415
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Karnataka INDIA.