What is Normalization ?

Answers were Sorted based on User's Feedback



What is Normalization ?..

Answer / lakshmi

Database normalization is a technique for designing
relational database tables to minimize duplication of
information and, in so doing, to safeguard the database
against certain types of logical or structural problems,
namely data anomalies.

For example, when multiple instances of a given piece of
information occur in a table, the possibility exists that
these instances will not be kept consistent when the data
within the table is updated, leading to a loss of data
integrity. A table that is sufficiently normalized is less
vulnerable to problems of this kind, because its structure
reflects the basic assumptions for when multiple instances
of the same information should be represented by a single
instance only.

Is This Answer Correct ?    169 Yes 26 No

What is Normalization ?..

Answer / darsh

It is a technique for designing a database system.

(BEST OF LUCK)

Is This Answer Correct ?    157 Yes 57 No

What is Normalization ?..

Answer / darsh

It is a technique for designing a database system.

(BEST OF LUCK)

Is This Answer Correct ?    114 Yes 54 No

What is Normalization ?..

Answer / abhinaw kaushik

Normalization is the process of braking down one table into
more than one tables so that data redudancy can be removed.
There are some rules to perform Normalization are called
Normal Forms.

Is This Answer Correct ?    51 Yes 11 No

What is Normalization ?..

Answer / ram

to avoiding duplicate data and easy maintence
it depends on entity relationship between columns

Is This Answer Correct ?    49 Yes 13 No

What is Normalization ?..

Answer / amarnath

The formal classifications describing the level of database
normalization in a data model are called Normal Forms (NF)
and the process of doing this is Normalization.

First normal form :
· A table is in first normal form when it contains no
repeating groups.
· The repeating column or fields in an un normalized table
are removed from the table and put in to tables of their own.
· Such a table becomes dependent on the parent table from
which it is derived.
· The key to this table is called concatenated key, with the
key of the parent table forming a part it.

Second normal form:
· A table is in second normal form if all its non_key fields
fully dependent on the whole key.
· This means that each field in a table ,must depend on the
entire key.
· Those that do not depend upon the combination key, are
moved to another table on whose key they depend on.
· Structures which do not contain combination keys are
automatically in second normal form.
Third normal form:
· A table is said to be in third normal form , if all the
non key fields of the table are independent of all other non
key fields of the same table.

Is This Answer Correct ?    27 Yes 4 No

What is Normalization ?..

Answer / kamal pratap singh

Normalization is the process of reduce the redundency in
database which is usefull for maintain the database very
smoothly and fast processing.

Is This Answer Correct ?    22 Yes 3 No

What is Normalization ?..

Answer / anshu

It is a technique to simple the design of database system.

Is This Answer Correct ?    69 Yes 51 No

What is Normalization ?..

Answer / sanjit

Step-by-step breakdown of complex data structure into simple
ones without loss of any information and relationship.

Is This Answer Correct ?    34 Yes 16 No

What is Normalization ?..

Answer / jannath

Normalization is the Process of reducing a complex data
structure into its simplest and most stable form by
eliminating redundant attributes, keys, and relationships.

Is This Answer Correct ?    14 Yes 1 No

Post New Answer

More Oracle General Interview Questions

where do i find oracle interview questions.

1 Answers  


What is DTS and purpose of DTS ?

1 Answers   TCS,


write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"

7 Answers   British Telecom BT,


What is a view and how is it different from a table?

0 Answers  


Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

0 Answers  






What is PL/SQL ?

0 Answers  


What is not equal to in oracle?

0 Answers  


What is the difference between alert log file and trace file ?

1 Answers  


how to get the no employee in each department including the dept which has 0 employee

5 Answers  


1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.

1 Answers   Wipro,


What is a server parameter file in oracle?

0 Answers  


What is oracle join syntax?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)