Answer / aravind

NORMALIZATION IS NOTHING BUT A BAD DATABASE TO CONVER INTO
THE GOOD ONE.THEN ELEMINATE THE DETERMINATION

Answer / sourb mahajan

It is a process during which redundant relation schemes are
decomposed by breaking up their attributes into smaller
relation schemes that possess desirable properties.

Answer / manikandan.s

-> Normalization is the Logical Data Base Design.
-> It's Used to Split the One table to multiple Table.
-> It's used to Reduce the Redundancy of data.

Answer / sudhir g. mali

To Resolve DB issues(inconsistency, redundancy & ambiguity) some amount of refinement required. This refinement process is called as Normalization.

Answer / gopal sharma

In the field of relational database design, normalization is a systematic way of ensuring that a database structure is suitable for general-purpose querying and free of certain undesirable characteristics—insertion, update, and deletion anomalies—that could lead to a loss of data integrity.[1]

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.


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.

Answer / vikas mohan

It is a technique for designing a database system and 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.
and also reducing duplication in the database,with
the ultimate goal of eliminating duplicate data entirely.

all the best

Answer / shivag

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

Answer / mohan

Normalization is The process of decomposing tables to eliminate data redundancy is called Normalization.

Answer / edward

NORMALIZATION IS THE WAY AND MANA OF REDUCING DUPLICATE IN
A GIVEN ENTITIES.

Answer / dastagiri babu(mca),s.v.pg col

Normalization is a technique which is used to make complex
physical structure into simple physical structure. By using
normalization we can get Redundant free structure(Elimation
of duplicate values)
Advantages:-
1. Redundancy will be reduced
2. Inconsistency will be avoided
3. Related data will be stored in tables

Which is faster join or subquery in oracle?

0 Answers  

We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?

3 Answers  

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..

2 Answers  

what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?

2 Answers  

what are the database links ?

2 Answers  

What are the varoius components of physical database structure of oracle database?

0 Answers  

How to select an oracle system id (sid)?

0 Answers  

What are the most common interview questions on ETL Testing for experience?

0 Answers  

How to loop through data rows in the implicit cursor?

0 Answers  

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

0 Answers   Infosys,

 What are the oracle DML commands possible through an update strategy?

0 Answers   Informatica,

How to use "out" parameter properly?

0 Answers