What is normalization ?
Answers were Sorted based on User's Feedback
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 |
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 |
Normalization is the process of organizing the table to
remove redundancy.
Is This Answer Correct ? | 8 Yes | 0 No |
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 |
Answer / abc
normalization is a process to remove data redundancy
Is This Answer Correct ? | 5 Yes | 0 No |
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 |
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 |
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 |
Can We write bulk collect statement in triggers?
What is the difference between delete and truncate commands?
What is a package ? What are the advantages of packages ?
How to convert comma separated string to array in pl/sql?
How does one load ebcdic data? : aql loader
Why is sql*loader direct path so fast?
what is cursor procedure
What is the location of pre_defined_functions.
Explain locks? : Transact sql
Explian rowid, rownum?
Give the order of sql select?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba