What is normalization ?

Answers were Sorted based on User's Feedback



What is normalization ?..

Answer / sohail

Normalization is a rule applied on the database table in
order to remove redundancy of data.

Is This Answer Correct ?    12 Yes 1 No

What is normalization ?..

Answer / lakshmi

Normalization is the process of breaking of data and
storing it into different tables to reduce the redundency
and to avoid nulls

Is This Answer Correct ?    10 Yes 0 No

What is normalization ?..

Answer / suresh somayajula

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

Is This Answer Correct ?    8 Yes 0 No

What is normalization ?..

Answer / amruta

It is a step by step process to decompose or brake a large
table into smaller no of tables. To eliminate Insertion,
updating and deletion anomalies.

Is This Answer Correct ?    7 Yes 2 No

What is normalization ?..

Answer / abc

normalization is a process to remove data redundancy

Is This Answer Correct ?    5 Yes 0 No

What is normalization ?..

Answer / ganesh

Normalization is the process of splitting a table into
smaller units to avoid redundancy and reducing the retrieval
time of a data. Let consider if your table having more than
one million records. Now you want to pick up the name or
data of a particular person in a table. It will take much
time to display the data. To overcome this drawback we user
normalization.

Is This Answer Correct ?    3 Yes 0 No

What is normalization ?..

Answer / dhivya

Normalization is a process of designing a database in which
the redundancy is avoided. It includes several Normal forms
namely 1NF, 2NF, 3NF, BCNF, 5NF etc...

Is This Answer Correct ?    3 Yes 0 No

What is normalization ?..

Answer / seenuvasan.a

It is a process of the analysing the given relation schemas based on their Functional Dependency(FDs) and primary key to achieve the properties,

-> Minimizing redundancy.
-> Minimizing insertion,deletion,and update anomalies.

Is This Answer Correct ?    1 Yes 0 No

What is normalization ?..

Answer / priya

can you explain with example...

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More SQL PLSQL Interview Questions

how to use case expression? : Sql dba

0 Answers  


difference between SQL and C

1 Answers   Indus Software Technologies,


----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6

4 Answers   ICICI,


What is sql stand for?

0 Answers  


What is a common use of group by in sql?

0 Answers  






one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?

13 Answers   Cap Gemini, TCS,


What do you understand by case manipulation functions?

0 Answers  


how many triggers are allowed in mysql table? : Sql dba

0 Answers  


What is the use of procedures?

0 Answers  


What do you mean by dbms? What are its different types?

0 Answers  


can i use dbms_output.put_line in a function u are telling as return statement

7 Answers  


If a View on a single base table is manipulated will the changes be reflected on the base table?

5 Answers  


Categories