Answer / shantanub

Normalization is the process of organizing data in a
database. This includes creating tables and establishing
relationships between those tables according to rules
designed both to protect the data and to make the database
more flexible by eliminating two factors: redundancy and
inconsistent dependency.

Answer / chethan sy

Normalization is a process of removing redundancy from the
tables.

De-normalization is introducing redundancy.

Answer / koti

In relational database design, the process of organizing
data to minimize redundancy. Normalization usually involves
dividing a database into two or more tables and defining
relationships between the tables. The objective is to
isolate data so that additions, deletions, and modifications
of a field can be made in just one table and then propagated
through the rest of the database via the defined relationships.

De-normalization is introducing redundancy.

Answer / srinivas

Normalization is the process of eliminating the duplicate , inconsistent data in the database..

As well denormalization is the process of introducing the redundancy to the data

Answer / hari

Normalization - is the process of desing of the datamodel
and effocential storre the data in database

Answer / ranjeet

normalization is used to remove data redundancy and
inconsitancy and we can perform the indexing,serching and
shorting the data in very easy manner

Answer / sarika desai

Normalization is a concept of Eliminating data redundancy,
Improve database performance & Index Improvement.

De-normalization is the process of attempting to optimize
the performance of a database by adding redundant data.

Answer / abdul quadir parihar

Normalization is the process of decomposition of complex
data in to simple way.

Denormalization is basically applied in the case the
database is over-normalised and no. of joins required to
fetch the data are too much. It is a purposeful redundancy
of some of the data to avoid the overhead of joins.

Answer / sandeep yadav

Normalization is the process of decomposition of complex
data in to simple way.
Denormalization is vice versa.

Explain why variables called the most powerful component of ssis?

0 Answers  

How to write character string constants or literals in ms sql server?

0 Answers  

Explain what are the authentication modes in sql server?

0 Answers  

How do you read transaction logs

1 Answers  

Describe in brief sql server monitoring ways.

0 Answers  

What is an index. What are the types?

0 Answers  

Name the different type of indexes in sql?

0 Answers  

What are sparse columns?

0 Answers  

What does it mean if @@cursor_row returns a negative number?

0 Answers  

How to get a list all databases on the sql server?

0 Answers  

What is the maximum size of a row in sql server?

0 Answers  

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers