What is Normalization ?
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 happens in oracle commit?
what is the syntax of ALTER command?
What is the disadvantage of User defind function?
How to define an anonymous block?
How do we represent comments in oracle?
Explain about functional dependency and its relation with table design?
How you open and close a cursor variable.Why it is required?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
Explain the characteristics of oracle dba?
create one table to capture an employee details with a primary key.