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 |
What is sql key?
how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently
Are subqueries faster than joins?
what are date and time data types? : Sql dba
Can you alter start with clause?
How to recompile a already made trigger?
what is a field in a database ? : Sql dba
What trigger means?
How to start oracle sql developer?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
What are its different types of dbms?
How can we store rows in PL/SQL using array?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)