Answer / sohail

Normalization is a rule applied on the database table in
order to remove redundancy of data.

Answer / lakshmi

Normalization is the process of breaking of data and
storing it into different tables to reduce the redundency
and to avoid nulls

Answer / suresh somayajula

Normalization is the process of organizing the table to
remove redundancy.

Answer / amruta

It is a step by step process to decompose or brake a large
table into smaller no of tables. To eliminate Insertion,
updating and deletion anomalies.

Answer / abc

normalization is a process to remove data redundancy

Answer / ganesh

Normalization is the process of splitting a table into
smaller units to avoid redundancy and reducing the retrieval
time of a data. Let consider if your table having more than
one million records. Now you want to pick up the name or
data of a particular person in a table. It will take much
time to display the data. To overcome this drawback we user
normalization.

Answer / dhivya

Normalization is a process of designing a database in which
the redundancy is avoided. It includes several Normal forms
namely 1NF, 2NF, 3NF, BCNF, 5NF etc...

Answer / seenuvasan.a

It is a process of the analysing the given relation schemas based on their Functional Dependency(FDs) and primary key to achieve the properties,

-> Minimizing redundancy.
-> Minimizing insertion,deletion,and update anomalies.

Answer / priya

can you explain with example...

What does trigger mean in psychology?

0 Answers  

What is a column in a table?

0 Answers  

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

0 Answers  

What makes a good primary key?

0 Answers  

what is a cursor

9 Answers   IBM, TCS, Wipro,

What does “select count(1) from tab” result?

10 Answers   IBM,

cursor types? explain with example programs?

1 Answers   HP,

Explain 3 basic parts of a trigger.

0 Answers  

Can we insert delete data in view?

0 Answers  

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

0 Answers   TCS,

What do you think about pl/sql?

0 Answers  

What are local and global variables and their differences?

0 Answers