Interested to Buy Any Domain ? << Click Here >> for more details...
What is Normalization ?
- 55 Answers
- 85862 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 |
what r routers?
How to find the date and time of last updated table?
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
Explain how are indexes update?
How to use fetch statement in a loop?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
What are the attributes that are found in a cursor?
what is difference between where clause and having clause?
sql command 2 know current database
which is best institue to learn oracle 11i in ameerpet or maithrivanam or sr nagar please help
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions
Oracle General 
