Interested to Buy Any Domain ? << Click Here >> for more details...
What is Normalization ?
- 55 Answers
- 86358 Views
- ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / santosh sagar
Database normalization is a process in which data in a
single table is being replaced into number of tables with
the same data along with some key relationships being set
up among the tables.
| Is This Answer Correct ? | 29 Yes | 19 No |
Answer / deep
Normalization means "The imposition of standards or
regulations". In the context of Relational Database Systems,
Database Normalization specifies a set of rules that splits
up a relational schema into a number of smaller subschemas,
in the objective of eliminating database anomalies. Database
normalization ensures that the data integrity and
consistency of the database is maintained. Each table in a
relational schema has a highest normal form indicating the
table's degree of vulnerability to logical inconsistencies
and anomalies. Database Normalization defines the steps to
decrease the degree of vulnerability in database systems.
Edgar F. Codd, the inventor of the relational model,
introduced the concept of normalization which is carried out
by the database designer of relational systems.
To determine and to achieve a highest normal form of
database systems please read
http://basudip.hubpages.com/hub/Database-Normalization
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / ron
Note:
1. data is normalized in oltp systems
( are of different forms :1NF, 2NF, 3NF, BCNF, 4NF,
5NF,DKNF,6NF)
2. when it comes to olap/datawarehouse/dss sytems data is
generally de-normalized. (N1NF, PNF).
there is always a trade-off to consider between data
redundancy vs performance
| Is This Answer Correct ? | 37 Yes | 28 No |
Answer / akhbaat haque sangita
The process of decomposing tables to eliminate data
redundancy is called Normalization.
| Is This Answer Correct ? | 14 Yes | 6 No |
Answer / amit tailor
Database normalization is the process of organizing data
into distinct and unique sets.
The purposes of normalization are to:
• Reduce or eliminate storage of duplicate data
• Organize data into an efficient and logica
structure
| Is This Answer Correct ? | 9 Yes | 3 No |
Defination : 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.
Benefits :
Eliminate data redundancy
Improve performance
Query optimization
Faster update due to less number of columns in one table
Index improvement
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / aushka
It is process of reducing duplication in the database,with
the ultimate goal of eliminating duplicate data entirely.
| Is This Answer Correct ? | 9 Yes | 6 No |
Answer / rajesh kumar
NORMALIZATION IS A TECNIQUE THAT IS USE TO SIMPLIFINE THE
RELATIONSHIP AMONG DATA ELEMENTS OF RECORD .IT REDUSE THE
DUPLICASY VALUE.IT IS GIVEN BY EF CODD IN 1972.HA GIVES
THREE NF(NORMAL FORM)1NF,2NF,3NF
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / n.srivani
Normalization is a process to reduce the redundant data in
the database.
| Is This Answer Correct ? | 5 Yes | 3 No |
How to work with data objects interactively?
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?
Explain the characteristics of oracle dba?
what diffrence between function and procedure?
How can we create the complete backup of data in the oracle.
0 Answers IPEC, Satyam, SunTec,
How translate command is different from replace?
How to invoke the data pump export utility?
How can I create database in oracle?
waht is the difference between primary key and super key?
What is an Oracle index?
How to fetch the row which has the max value for a column?
Oracle General 
