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 |
Difference between varchar and varchar2 data types?
How to delete all rows a table in oracle?
if you update view? where we store the data?
What is a Data Segment ?
Is oracle the best database?
How to define a variable to match a table column data type?
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
What is pragma autonomous transaction in oracle?
What are the differences between interval year to month and interval day to second?
What is ASM (Automatic Storage Management) in Oracle?
Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)