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 recursive stored procedure?
How do I run a sql query?
How delete a row in sql?
What is the difference between a primary key and a clustered index?
How do I save a stored procedure?
SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/
How to convert comma separated string to array in pl/sql?
what are dynamic queries in t-sql? : Transact sql
what is difference b/w pravite procedures and public procedures?
3 Answers Steria, Wipro, Zensar,
What is pl sql script?
What is the difference between left join and right join?
What is oracle sql developer?
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)